Define a SQL view Q5(course_code)that gives the code of the courses that have the highest number of
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Related Book For
Posted Date: