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