diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:34:31 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:34:31 +0000 |
| commit | eb46a159727eea19e7015cd09bf0174e5bcbe15e (patch) | |
| tree | ebaefae742160694a8b133553161c1d758b1cb4a /wk7/pset/movies/13.sql | |
| parent | 3a1473c9026dd27617ba94794ddfda091e7a7c19 (diff) | |
Mon, May 20, 2024, 4:34 AM -07:00
Diffstat (limited to 'wk7/pset/movies/13.sql')
| -rw-r--r-- | wk7/pset/movies/13.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/wk7/pset/movies/13.sql b/wk7/pset/movies/13.sql index e69de29..1109cd1 100644 --- a/wk7/pset/movies/13.sql +++ b/wk7/pset/movies/13.sql @@ -0,0 +1,20 @@ +SELECT name +FROM people +WHERE id IN ( + SELECT movie_id + FROM stars + WHERE person_id = ( + SELECT id + FROM people + WHERE name = "Bradley Cooper" + ) +) AND ( + SELECT movie_id + FROM stars + WHERE person_id = ( + SELECT id + FROM people + WHERE name = "Jennifer Lawrence" + ) +) +; |