diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 04:46:03 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-21 04:46:03 +0000 |
| commit | f8dfcdd03198d1d29eb76db7eca8258afece9c3e (patch) | |
| tree | 845cc3e4f5432b06ba242a673e76da1bba7321b8 /wk7/pset/movies/9.sql | |
| parent | 0bada9829c75ae04cabecee6b1599e0675cde9bf (diff) | |
Mon, May 20, 2024, 9:46 PM -07:00
Diffstat (limited to 'wk7/pset/movies/9.sql')
| -rw-r--r-- | wk7/pset/movies/9.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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 |