wk7/pset/movies/9.sql


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

SELECT name
FROM people
WHERE id IN (
    SELECT person_id
    FROM stars
    WHERE movie_id IN (
        SELECT id
        FROM movies
        WHERE year = 2004
        )
    )
ORDER BY birth;