From 409c933af61e2e4f7c75a3aaf067f53b483fbbff Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Tue, 21 May 2024 05:02:07 +0000
Subject: Mon, May 20, 2024, 10:02 PM -07:00

---
 wk7/pset/movies/12.sql | 20 ++++++++++----------
 1 file changed, 10 insertions(+), 10 deletions(-)

(limited to 'wk7/pset/movies/12.sql')

diff --git a/wk7/pset/movies/12.sql b/wk7/pset/movies/12.sql
index fdc2345..08ab491 100644
--- a/wk7/pset/movies/12.sql
+++ b/wk7/pset/movies/12.sql
@@ -6,15 +6,15 @@ WHERE id IN (
     WHERE person_id = (
         SELECT id
         FROM people
-        WHERE name = "Bradley Cooper"
+        WHERE name = 'Bradley Cooper'
     )
-) AND (
-    SELECT movie_id
-    FROM stars
-    WHERE person_id = (
-        SELECT id
-        FROM people
-        WHERE name = "Jennifer Lawrence"
+    AND movie_id IN (
+        SELECT movie_id
+        FROM stars
+        WHERE person_id = (
+            SELECT id
+            FROM people
+            WHERE name = 'Jennifer Lawrence'
+        )
     )
-)
-;
+);
-- 
cgit v1.2.3

