The table used on this exercise provides information about the ranking of popular songs worldwide. The following questions are provided with the correct SQL query and graphs using the graphics function in Strata Scratch.
datasets.spotify_worldwide_daily_song_ranking table to answer the questions below.
Which songs have more than 3 million streams?
Which songs had been frequently placed in the top 1 position over the years?
Which artists have been on Spotify the most?
Which artists had the most top 10 songs over the years?
Which songs have less than 2000 streams?
What are the top 10 songs listened to?
What is the average number of streams over all songs?
How many streams are in the top 100?
What is the highest number of streams in the dataset?
Which songs are placed in the positions 8-10?