From 0b68b3b0b5076b94f9eed9f234a9c52ac4f4b989 Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Tue, 21 May 2024 04:53:45 +0000
Subject: Mon, May 20, 2024, 9:53 PM -07:00

---
 wk7/pset/movies/12.sql | 8 +++-----
 1 file changed, 3 insertions(+), 5 deletions(-)

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