1SELECT 
2    playlist_genre AS Genre,
3    AVG(duration_ms) / 60000 AS Average_Duration_Minutes,
4    AVG(track_popularity) AS Average_Popularity,
5    AVG(tempo) AS Average_Tempo,
6    AVG(loudness) AS Average_Loudness
7FROM 
8    @kaggle.joebeachcapital_30000_spotify_songs.spotify_songs
9GROUP BY 
10    playlist_genre
11ORDER BY 
12    playlist_genre;
13