diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 10:49:01 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 10:49:01 +0000 |
| commit | b719349202f356a42c89cdab32d86af2d890ab2b (patch) | |
| tree | ab81489c46ab3a76265a779ae0b3c1ba6d5054da /wk7/pset/movies/7.sql | |
| parent | ef596949cab600b4263169b3a73e05fc61de01d0 (diff) | |
Mon, May 20, 2024, 3:49 AM -07:00
Diffstat (limited to 'wk7/pset/movies/7.sql')
| -rw-r--r-- | wk7/pset/movies/7.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/wk7/pset/movies/7.sql b/wk7/pset/movies/7.sql index 2995ab0..8e28bfd 100644 --- a/wk7/pset/movies/7.sql +++ b/wk7/pset/movies/7.sql @@ -1 +1 @@ -SELECT title FROM movies WHERE movie_id IN (SELECT id FROM movies WHERE year = 2012); +SELECT title, rating FROM movies JOIN ratings ON movies.id = ratings.movie_id WHERE year = 2010 ORDER BY rating DESC; |