diff options
Diffstat (limited to 'wk7/pset')
| -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 |