1 files changed, 9 insertions, 5 deletions
diff --git a/wk7/pset/movies/11.sql b/wk7/pset/movies/11.sql
index fd4ade1..4162617 100644
--- a/wk7/pset/movies/11.sql
+++ b/wk7/pset/movies/11.sql
@@ -1,10 +1,14 @@
 SELECT title
 FROM movies
-JOIN ratings ON movies.id = ratings.movie_id
-WHERE person_id = (
-    SELECT id
-    FROM people
-    WHERE name = "Chadwick Boseman"
+-- JOIN ratings ON movies.id = ratings.movie_id
+WHERE id IN (
+    SELECT movie_id
+    FROM ratings
+    WHERE person_id = (
+        SELECT id
+        FROM people
+        WHERE name = "Chadwick Boseman"
+    )
 )
 ORDER BY rating
 ;