Baselight
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;
GenreAverage_Duration_MinutesAverage_PopularityAverage_TempoAverage_Loudness
edm3.70901430580837334.83352639417508125.7680243256656-5.427445143140832
latin3.61439078241189847.026576139670226118.62235363724567-6.264454704170704
pop3.62946840384964647.74487016524424120.74317831850318-6.3153281278373
r&b3.95999149634812541.22353157797827114.22215558828988-7.8648479101454605
rap3.569398152337858443.21545422902889120.65490758788768-7.042269404803333
rock4.14294167171615241.72833770955363124.9887859018381-7.588894970713006

Share link

Anyone who has the link will be able to view this.