please let me know if the query below for question 1 of case study 1 is correct or not.I have also attached the result.
