1 files changed, 12 insertions, 0 deletions
diff --git a/wk7/pset/movies/10.sql b/wk7/pset/movies/10.sql
index e69de29..d87bef6 100644
--- a/wk7/pset/movies/10.sql
+++ b/wk7/pset/movies/10.sql
@@ -0,0 +1,12 @@
+SELECT name
+FROM people
+WHERE id IN (
+    SELECT person_id
+    FROM stars
+    WHERE movie_id = (
+        SELECT id
+        FROM movies
+        WHERE year = 2004
+        )
+    )
+;