i don't know the actual answer for the question
according to me answer should be A please confirm it
due to there is '=' operator missing in WHERE year 'FY' ?
otherwise it will give option A.
Shaik Masthan inside the inner query they have not included COURSE in from clause so is it valid to access Course relation's attributes in inner query