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/pset/movies') 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