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