summaryrefslogtreecommitdiff
path: root/wk7/pset/movies
diff options
context:
space:
mode:
authorFudgerboy <91767657+Fudgerboy@users.noreply.github.com>2024-05-20 11:50:51 +0000
committerFudgerboy <91767657+Fudgerboy@users.noreply.github.com>2024-05-20 11:50:51 +0000
commit0e697cd2c703bea4a06e37ee930c8f3c1325dad1 (patch)
tree3cc104e3ea092e908aa5ac23f6602d1903e1b587 /wk7/pset/movies
parenta16051d7767114b948f0e9cf2b2634543817f9de (diff)
Mon, May 20, 2024, 4:50 AM -07:00
Diffstat (limited to 'wk7/pset/movies')
-rw-r--r--wk7/pset/movies/7.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/wk7/pset/movies/7.sql b/wk7/pset/movies/7.sql
index 80f3345..9e08f4c 100644
--- a/wk7/pset/movies/7.sql
+++ b/wk7/pset/movies/7.sql
@@ -2,5 +2,5 @@ SELECT title, rating
FROM movies
JOIN ratings ON movies.id = ratings.movie_id
WHERE year = 2010
-ORDER BY rating DESC
+ORDER BY rating DESC, title
;