Mostly questions asked where subquery is required they wanted to see if we are able to fetch records from database using multiple joins and subquery. Also the theortical part should be crystal clear like normalisation Indexes etc