diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:28:00 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:28:00 +0000 |
| commit | 5d7a128204108ca96b6a35a4c43ed01de24b0bb8 (patch) | |
| tree | 59b883939b6190d89c773303111538cd6ad151a3 /wk7/pset | |
| parent | 7497b86c69707914ed378d5245bc3840c0e516ae (diff) | |
Mon, May 20, 2024, 4:28 AM -07:00
Diffstat (limited to 'wk7/pset')
| -rw-r--r-- | wk7/pset/movies/11.sql | 14 |
1 files changed, 9 insertions, 5 deletions
diff --git a/wk7/pset/movies/11.sql b/wk7/pset/movies/11.sql index fd4ade1..4162617 100644 --- a/wk7/pset/movies/11.sql +++ b/wk7/pset/movies/11.sql @@ -1,10 +1,14 @@ SELECT title FROM movies -JOIN ratings ON movies.id = ratings.movie_id -WHERE person_id = ( - SELECT id - FROM people - WHERE name = "Chadwick Boseman" +-- 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 ; |