project 3 case study 2

i have written this querry but not getting the output. Before this also i have tried several more querries but not getting output. Can you please help me to get a recquired querry for task 2 of case study 2.I have attached the screenshot