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;