SMDB demo queries

smdb_demo_querries

/*
How much more dancable are The Youniverse than the average Slovak music?
<run separately after the / sign>
*/

select(
(select avg(danceability) as [The Youniverse - Danceability] from "spotify-top-tracks" where spotify_artist_name = "The Youniverse" ) /
(select avg(danceability) as [Average Danceability] from "spotify-top-tracks") - 1
)*100 as percent

/*
What is Katarzia's favorite key?
<run separately after the / sign> 
*/

select key as [Katarzia's most frequent key], count(key) Frequency
from "spotify-top-tracks" where spotify_artist_name = "Katarzia"
group by key order by count(key) desc