I'm stuck on pset7 10.sql, it keeps coming up with a misuse of aggregate function. My code is currently:
SELECT name FROM people INNER JOIN directors ON people.id = directors.person_id INNER JOIN ratings ON directors.movie_id = ratings.movie_id WHERE AVG(rating) >= 9.0
As the solution only asks for one column, I thought this would be the right way of doing it?
Thanks in advance