From dd9d9eb9053ae45f286eb5d84a6acb9a9e25be25 Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Mon, 20 May 2024 11:13:03 +0000
Subject: Mon, May 20, 2024, 4:13 AM -07:00

---
 wk7/pset/movies/9.sql | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)

(limited to 'wk7')

diff --git a/wk7/pset/movies/9.sql b/wk7/pset/movies/9.sql
index 9b8ede8..dc05efb 100644
--- a/wk7/pset/movies/9.sql
+++ b/wk7/pset/movies/9.sql
@@ -1 +1,12 @@
-SELECT name FROM people 
+SELECT name
+FROM people
+WHERE id IN (
+    SELECT person_id
+    FROM stars
+    WHERE movie_id = (
+        SELECT id
+        FROM movies
+        WHERE year = 2004
+        )
+    )
+ORDER BY birth;
-- 
cgit v1.2.3