Persons id name address age eyeColor gender TakesClasses id personid → Persons classid →…
- User
Persons
id
name
address
age
eyeColor
gender
TakesClasses
id
person_id → Persons
class_id → Classes
- Assistant
Classes
id
name
teacher
start_date
end_date
Students
id
person_id → Persons
class_id → Classes
performance
attendance
- User
Write a query that returns a table with columns name and nrOfClasses that contains the list of all names of people and the number of classes if the person takes more classes than the average. I now have: select P.name as name, count(distinct T.class_id) as nrOfClasses from Persons P, TakesClasses T where P.id = T.person_id group by P.name having
- Assistant
COUNT(distinct T.class_id) > (SELECT AVG(count_classes) FROM ( SELECT P.id, COUNT(DISTINCT T.class_id) AS count_classes FROM Persons P, TakesClasses T WHERE P.id = T.person_id GROUP BY P.id) AS average_classes)