wk7/pset/movies/13.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

SELECT name
FROM people
WHERE id IN (
    SELECT person_id
    FROM stars
    WHERE movie_id = (
        SELECT movie_id
        FROM stars
        WHERE person_id = (
            SELECT id
            FROM people
            WHERE name = "Kevin Bacon"
            AND birth = 1958
        )
    )
)
AND NOT name = "Kevin Bacon"
;