wk7/pset/movies/10.sql


1
2
3
4
5
6
7
8
9

SELECT name
FROM people 
WHERE id IN (
    SELECT person_id
    FROM directors
    JOIN ratings ON directors.movie_id = ratings.movie_id
    WHERE rating >= 9.0
    )
;