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 +++------
 1 file changed, 3 insertions(+), 6 deletions(-)

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

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