From b79f8bc84ca74d1fdc7610cd9b39aadf607f0e60 Mon Sep 17 00:00:00 2001 From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> Date: Mon, 20 May 2024 11:18:26 +0000 Subject: Mon, May 20, 2024, 4:18 AM -07:00 --- wk7/pset/movies/7.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'wk7/pset/movies/7.sql') diff --git a/wk7/pset/movies/7.sql b/wk7/pset/movies/7.sql index 8e28bfd..80f3345 100644 --- a/wk7/pset/movies/7.sql +++ b/wk7/pset/movies/7.sql @@ -1 +1,6 @@ -SELECT title, rating FROM movies JOIN ratings ON movies.id = ratings.movie_id WHERE year = 2010 ORDER BY rating DESC; +SELECT title, rating +FROM movies +JOIN ratings ON movies.id = ratings.movie_id +WHERE year = 2010 +ORDER BY rating DESC +; -- cgit v1.2.3