wk7/pset/movies/10.sql


1
2
3
4
5
6
7
8
9
10
11
12

SELECT name
FROM people
WHERE id IN (
    SELECT person_id
    FROM directors
    WHERE movie_id = (
        SELECT id
        FROM movies
        WHERE year = 2004
        )
    )
;