wk7/pset/movies/13.sql


1
2
3
4
5
6
7
8
9
10
11

SELECT name
FROM people
WHERE id IN (
    SELECT person_id
    FROM stars
    WHERE movie_id = (
        SELECT id
        FROM movies
    )
)
;