From b719349202f356a42c89cdab32d86af2d890ab2b Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Mon, 20 May 2024 10:49:01 +0000
Subject: Mon, May 20, 2024, 3:49 AM -07:00

---
 wk7/pset/movies/7.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'wk7/pset/movies/7.sql')

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;
-- 
cgit v1.2.3

