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)
PayPal Gateway not configured
PayPal Gateway not configured