summaryrefslogtreecommitdiff
path: root/wk7/pset/songs
diff options
context:
space:
mode:
authorFudgerboy <91767657+Fudgerboy@users.noreply.github.com>2024-05-20 10:10:13 +0000
committerFudgerboy <91767657+Fudgerboy@users.noreply.github.com>2024-05-20 10:10:13 +0000
commitc5a9f1c879416e6e6cdd1a5c0135df66005ffd54 (patch)
tree7b59ddaff6bdae6dc67e1b1b797adc0d0072269e /wk7/pset/songs
parentacd029a8f9f74da8776f059b288a4ba59b228a2d (diff)
Mon, May 20, 2024, 3:10 AM -07:00
Diffstat (limited to 'wk7/pset/songs')
-rw-r--r--wk7/pset/songs/7.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/wk7/pset/songs/7.sql b/wk7/pset/songs/7.sql
index e69de29..daf056e 100644
--- a/wk7/pset/songs/7.sql
+++ b/wk7/pset/songs/7.sql
@@ -0,0 +1 @@
+SELECT AVG(energy) FROM songs WHERE artist_id = (SELECT id FROM artists WHERE name = 'Drake');