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