diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:18:26 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:18:26 +0000 |
| commit | b79f8bc84ca74d1fdc7610cd9b39aadf607f0e60 (patch) | |
| tree | 7c13c3304310d79f5b060d07c6c3e7e75273fd78 | |
| parent | 480e906eb0af88574722702c83498653e6f59604 (diff) | |
Mon, May 20, 2024, 4:18 AM -07:00
| -rw-r--r-- | wk7/pset/movies/10.sql | 9 | ||||
| -rw-r--r-- | wk7/pset/movies/7.sql | 7 |
2 files changed, 9 insertions, 7 deletions
diff --git a/wk7/pset/movies/10.sql b/wk7/pset/movies/10.sql index db2a0e1..e5a0792 100644 --- a/wk7/pset/movies/10.sql +++ b/wk7/pset/movies/10.sql @@ -1,12 +1,9 @@ SELECT name -FROM people +FROM people WHERE id IN ( SELECT person_id FROM directors - WHERE movie_id = ( - SELECT id - FROM movies - WHERE year = 2004 - ) + JOIN ratings ON directors.movie_id = ratings.movie_id + WHERE rating >= 9.0 ) ; diff --git a/wk7/pset/movies/7.sql b/wk7/pset/movies/7.sql index 8e28bfd..80f3345 100644 --- a/wk7/pset/movies/7.sql +++ b/wk7/pset/movies/7.sql @@ -1 +1,6 @@ -SELECT title, rating FROM movies JOIN ratings ON movies.id = ratings.movie_id WHERE year = 2010 ORDER BY rating DESC; +SELECT title, rating +FROM movies +JOIN ratings ON movies.id = ratings.movie_id +WHERE year = 2010 +ORDER BY rating DESC +; |