diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:29:42 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 11:29:42 +0000 |
| commit | e419d486012c51895ff73cbeb9a309d6b9a1255c (patch) | |
| tree | f4cbf18cd845796b7fdb5b24b6cf66b84f814831 /wk7/pset/movies | |
| parent | 5d7a128204108ca96b6a35a4c43ed01de24b0bb8 (diff) | |
Mon, May 20, 2024, 4:29 AM -07:00
Diffstat (limited to 'wk7/pset/movies')
| -rw-r--r-- | wk7/pset/movies/11.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/wk7/pset/movies/11.sql b/wk7/pset/movies/11.sql index 4162617..5f36f1f 100644 --- a/wk7/pset/movies/11.sql +++ b/wk7/pset/movies/11.sql @@ -1,9 +1,9 @@ SELECT title FROM movies --- JOIN ratings ON movies.id = ratings.movie_id +JOIN ratings ON movies.id = ratings.movie_id WHERE id IN ( SELECT movie_id - FROM ratings + FROM stars WHERE person_id = ( SELECT id FROM people |