diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:42:55 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:42:55 +0000 |
| commit | 3caa9b7fe3be0879516c836a874d3cb683871e11 (patch) | |
| tree | 94a6823be671811adca07404fc6b677ac0388518 /wk7/pset/movies/13.sql | |
| parent | 69ddca52613ceed0601fa7a15fd8c0ce192fa0e0 (diff) | |
Mon, May 20, 2024, 4:42 AM -07:00
Diffstat (limited to 'wk7/pset/movies/13.sql')
| -rw-r--r-- | wk7/pset/movies/13.sql | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/wk7/pset/movies/13.sql b/wk7/pset/movies/13.sql index e8ca7a7..3d51903 100644 --- a/wk7/pset/movies/13.sql +++ b/wk7/pset/movies/13.sql @@ -4,8 +4,15 @@ WHERE id IN ( SELECT person_id FROM stars WHERE movie_id = ( - SELECT id - FROM movies + SELECT movie_id + FROM stars + WHERE person_id = ( + SELECT id + FROM people + WHERE name = "Kevin Bacon" + AND birth = 1958 + ) ) + NOT name = "Kevin Bacon" ) ; |