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