diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 10:43:41 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 10:43:41 +0000 |
| commit | a536e4a3d1f8401d11938a519fb37d18f75eefe0 (patch) | |
| tree | 6d432176aca3f2d46fc7f17e682de7babeecb229 /wk7/pset | |
| parent | f3d20a432f965c5b1bd64e3491eb3d5461edee0a (diff) | |
Mon, May 20, 2024, 3:43 AM -07:00
Diffstat (limited to 'wk7/pset')
| -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); |