(Solved) : Head School Would Like Know Performance Students Set Cse Subjects Subjects Set Subject Cod Q37103051 . . . .

The head of school would like to know the performance ofstudents in a set of CSE subjects. Subjects in this set have theirsubject codes starting with “COMP90” and are offered in every majorsemester (i.e., S1 and S2) in a given period (from 2003 (inclusive)to 2012 (inclusive)). To evaluate the performance of students, thehead of school requested to know the PASS rate in every majorsemester in the given period. The PASS rate is defined as thenumber of students who have got PASS (Course_enrolments.mark >=50) / number of students who have actually received a mark (i.e.Course_enrolments.mark >= 0). Define an SQL viewQ12(code,name,year,s1_ps_rate,s2_ps_rate)