Define a SQL view Q5(course_code)that gives the code of the courses that have the highest

number of students failed among all the courses offered by the same faculty in the year 2010. If

there are multiple courses sharing the highest number of failed students, list all the course_code

of these courses.

• course

_

code should be taken from Subjects.code of the corresponding subject;

• Faculties refer to the organization units where their Orgunit_types.name are 'Faculty';

• Failing a course means that the grade a student received for a course is 'FL'.

 

Pls fix and continue and add to below code

create or replace view Q5(course_code) as

select s.code

from subjects s

join origunits o on o.id=s.offeredby

join orgunit_types ot on ot.id=o.utype

join courses c on c.subject=s.id

join course_enrolments ce on ce.course=c.id

join semesters se on c.semester=se.id

 

ot.name='Faculty'

ce.grade='FL'

se.year=2010