From a536e4a3d1f8401d11938a519fb37d18f75eefe0 Mon Sep 17 00:00:00 2001
From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com>
Date: Mon, 20 May 2024 10:43:41 +0000
Subject: Mon, May 20, 2024, 3:43 AM -07:00

---
 wk7/pset/movies/6.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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);
-- 
cgit v1.2.3