project 3 case 2 first question

can you please check this query for question number 1 of case study 2.