diff options
Diffstat (limited to 'wk7')
| -rw-r--r-- | wk7/pset/movies/6.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/wk7/pset/movies/6.sql b/wk7/pset/movies/6.sql index a9edaec..f130d2c 100644 --- a/wk7/pset/movies/6.sql +++ b/wk7/pset/movies/6.sql @@ -1 +1 @@ -SELECT rating FROM ratings WHERE movie_id = (SELECT id FROM movies WHERE year = 2012); +SELECT AVG(rating) FROM ratings WHERE movie_id IN (SELECT id FROM movies WHERE year = 2012); |