1 files changed, 3 insertions, 6 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
     )
 ;