diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:25:11 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:25:11 +0000 |
| commit | 7497b86c69707914ed378d5245bc3840c0e516ae (patch) | |
| tree | 0467e311217794946933b59b0f0766670096d23b /wk7/pset/movies/11.sql | |
| parent | 5945548e7caf35ddbca4ff504b035f25932d5f38 (diff) | |
Mon, May 20, 2024, 4:25 AM -07:00
Diffstat (limited to 'wk7/pset/movies/11.sql')
| -rw-r--r-- | wk7/pset/movies/11.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/wk7/pset/movies/11.sql b/wk7/pset/movies/11.sql index 978cdcc..fd4ade1 100644 --- a/wk7/pset/movies/11.sql +++ b/wk7/pset/movies/11.sql @@ -1,7 +1,10 @@ SELECT title FROM movies JOIN ratings ON movies.id = ratings.movie_id -JOIN people ON ratings.person_id = people.id -WHERE name = "Chadwick Boseman" +WHERE person_id = ( + SELECT id + FROM people + WHERE name = "Chadwick Boseman" +) ORDER BY rating ; |