From f8dfcdd03198d1d29eb76db7eca8258afece9c3e Mon Sep 17 00:00:00 2001 From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> Date: Tue, 21 May 2024 04:46:03 +0000 Subject: Mon, May 20, 2024, 9:46 PM -07:00 --- wk7/pset/movies/9.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'wk7/pset') diff --git a/wk7/pset/movies/9.sql b/wk7/pset/movies/9.sql index 7c4647a..7eb7dc6 100644 --- a/wk7/pset/movies/9.sql +++ b/wk7/pset/movies/9.sql @@ -1,9 +1,9 @@ SELECT name FROM people -WHERE id = ( +WHERE id IN ( SELECT person_id FROM stars - WHERE movie_id = ( + WHERE movie_id IN ( SELECT id FROM movies WHERE year = 2004 -- cgit v1.2.3