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/10.sql | 9 +++------
 wk7/pset/movies/7.sql  | 7 ++++++-
 2 files changed, 9 insertions(+), 7 deletions(-)

diff --git a/wk7/pset/movies/10.sql b/wk7/pset/movies/10.sql
index db2a0e1..e5a0792 100644
--- a/wk7/pset/movies/10.sql
+++ b/wk7/pset/movies/10.sql
@@ -1,12 +1,9 @@
 SELECT name
-FROM people
+FROM people 
 WHERE id IN (
     SELECT person_id
     FROM directors
-    WHERE movie_id = (
-        SELECT id
-        FROM movies
-        WHERE year = 2004
-        )
+    JOIN ratings ON directors.movie_id = ratings.movie_id
+    WHERE rating >= 9.0
     )
 ;
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