From e419d486012c51895ff73cbeb9a309d6b9a1255c Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Mon, 20 May 2024 11:29:42 +0000
Subject: Mon, May 20, 2024, 4:29 AM -07:00
---
wk7/pset/movies/11.sql | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
(limited to 'wk7')
diff --git a/wk7/pset/movies/11.sql b/wk7/pset/movies/11.sql
index 4162617..5f36f1f 100644
--- a/wk7/pset/movies/11.sql
+++ b/wk7/pset/movies/11.sql
@@ -1,9 +1,9 @@
SELECT title
FROM movies
--- JOIN ratings ON movies.id = ratings.movie_id
+JOIN ratings ON movies.id = ratings.movie_id
WHERE id IN (
SELECT movie_id
- FROM ratings
+ FROM stars
WHERE person_id = (
SELECT id
FROM people
--
cgit v1.2.3