From eb53d27a41dfd626950289bdab99ace48ba84bdb Mon Sep 17 00:00:00 2001 From: Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> Date: Mon, 20 May 2024 10:06:56 +0000 Subject: Mon, May 20, 2024, 3:06 AM -07:00 --- wk7/pset/songs/5.sql | 2 +- wk7/pset/songs/6.sql | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) (limited to 'wk7') diff --git a/wk7/pset/songs/5.sql b/wk7/pset/songs/5.sql index c87ac9b..e737432 100644 --- a/wk7/pset/songs/5.sql +++ b/wk7/pset/songs/5.sql @@ -1 +1 @@ -SELECT AVG energy FROM songs +SELECT AVG(energy) FROM songs; diff --git a/wk7/pset/songs/6.sql b/wk7/pset/songs/6.sql index e69de29..f14fc54 100644 --- a/wk7/pset/songs/6.sql +++ b/wk7/pset/songs/6.sql @@ -0,0 +1 @@ +SELECT name FROM songs WHERE artist_id = -- cgit v1.2.3