summaryrefslogtreecommitdiff
path: root/wk7/pset/songs
diff options
context:
space:
mode:
Diffstat (limited to 'wk7/pset/songs')
-rw-r--r--wk7/pset/songs/5.sql2
-rw-r--r--wk7/pset/songs/6.sql1
2 files changed, 2 insertions, 1 deletions
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 =