SELECT
playlist_genre AS Genre,
AVG(duration_ms) / 60000 AS Average_Duration_Minutes,
AVG(track_popularity) AS Average_Popularity,
AVG(tempo) AS Average_Tempo,
AVG(loudness) AS Average_Loudness
FROM
@kaggle.joebeachcapital_30000_spotify_songs.spotify_songs
GROUP BY
playlist_genre
ORDER BY
playlist_genre;