diff options
Diffstat (limited to 'wk7')
| -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 ; |