SQL
By using subqueries:
1.For each course, show the number of students who got above the
class average.
2.Show the department with the highest difference in salary
between the highest paid and least paid of their faculty
members.
3.For each department, show the failure rate of their classes.
The failure rate is the total number of students who have failed a
class in that department divided by the number of students who have
completed the classes.
Sql By Using Subqueries 1 For Each Course Show The Number Of Students Who Got Above The Class Average 2 Show The Depa 1 (159.61 KiB) Viewed 21 times
uni_student stud_id varchar2(8) PK fullname varchar2(20) N DOB date email varchar2(20) uni_enrollment stud_id varchar2(8) PK FK course_id varchar2(8) PK FK grade number(3,0) course_id title dept_id lec_id start uni_course varchar2(8) PK varchar2(20) N varchar2(8) FK varchar2(20) FK date uni_department dept_id varchar2(8) PK name varchar2(20) N budget number(10,2) uni_lecturer varchar2(20) PK varchar2(20) number(10,2) varchar2(8) FK lec_id fullname salary dept_id +
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!