diff options
| author | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 10:06:56 +0000 |
|---|---|---|
| committer | Fudgerboy <91767657+Fudgerboy@users.noreply.github.com> | 2024-05-20 10:06:56 +0000 |
| commit | eb53d27a41dfd626950289bdab99ace48ba84bdb (patch) | |
| tree | cf3fe19fb60b59af318593ad01f1f85cf8ed5e87 | |
| parent | a1b18e4cd5a3624a12f5770b42be27a678bd80dc (diff) | |
Mon, May 20, 2024, 3:06 AM -07:00
| -rw-r--r-- | wk7/pset/songs/5.sql | 2 | ||||
| -rw-r--r-- | wk7/pset/songs/6.sql | 1 |
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 = |