Question: Write SQL query: Calculate the number and average GPA of those students who have never taken any course taught by Eric Lee. (The GPA of
Write SQL query:
Calculate the number and average GPA of those students who have never taken any course taught by Eric Lee. (The GPA of a student is simply the average of all his grades in TABLE GRADE. Students who have not taken any course do not have a GPA.)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
