wk7/pset/movies/11.sql


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

SELECT title
FROM movies
-- JOIN ratings ON movies.id = ratings.movie_id
WHERE id IN (
    SELECT movie_id
    FROM ratings
    WHERE person_id = (
        SELECT id
        FROM people
        WHERE name = "Chadwick Boseman"
    )
)
ORDER BY rating
;