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
+;