diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:14:14 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:14:14 +0000 |
| commit | 0211efa418d30b87195e17af4eb58429a06ab566 (patch) | |
| tree | dfc06c92feb30ca7d692f2dce59db8f498989050 /wk7/pset/movies/10.sql | |
| parent | dd9d9eb9053ae45f286eb5d84a6acb9a9e25be25 (diff) | |
Mon, May 20, 2024, 4:14 AM -07:00
Diffstat (limited to 'wk7/pset/movies/10.sql')
| -rw-r--r-- | wk7/pset/movies/10.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/wk7/pset/movies/10.sql b/wk7/pset/movies/10.sql index e69de29..d87bef6 100644 --- a/wk7/pset/movies/10.sql +++ b/wk7/pset/movies/10.sql @@ -0,0 +1,12 @@ +SELECT name +FROM people +WHERE id IN ( + SELECT person_id + FROM stars + WHERE movie_id = ( + SELECT id + FROM movies + WHERE year = 2004 + ) + ) +; |