SQL view Define a SQL view Q(code.name, semester) that displays the course that

Question

SQL view

Define a SQL view Q(code.name, semester) that displays the course that has the highest average mark. To avoid extreme situations, only consider courses which have at least 15 not null mark records (Course enrolments.mark). The view should return the following details about each course: code should be taken from Subjects.code field. name should be taken from Subjects.name field. * semester should be taken from Semesters.name field. Course_enrolments(course, mark) Subjects(id,code,name) Semesters(id,name) Courses(id, subject,semester)

Explanation / Answer

Create view Q as Select Subjects.code,Subjects.name,Semesters.name from Subjects inner join Courses on Subjects.id = Courses.subject inner join Semesters on Courses.semester = Semesters.id inner join Course_enrolments on Courses.id = Course_enrolments.course mark = ( Select max(avg(mark)) from Course_enrolments group by course having count(mark) >= 15 and mark is not null );

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.