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

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

(limited to 'wk7/pset')

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