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

---
 wk7/pset/movies/11.sql | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

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

diff --git a/wk7/pset/movies/11.sql b/wk7/pset/movies/11.sql
index 978cdcc..fd4ade1 100644
--- a/wk7/pset/movies/11.sql
+++ b/wk7/pset/movies/11.sql
@@ -1,7 +1,10 @@
 SELECT title
 FROM movies
 JOIN ratings ON movies.id = ratings.movie_id
-JOIN people ON ratings.person_id = people.id
-WHERE name = "Chadwick Boseman"
+WHERE person_id = (
+    SELECT id
+    FROM people
+    WHERE name = "Chadwick Boseman"
+)
 ORDER BY rating
 ;
-- 
cgit v1.2.3

