company sql set
Spotify
Spotify
SQL Set
Streams, artists, users, playlists, subscriptions, daily listeners, trends, and sessions.
question list
Work through all 10 questions
Open a problem, write the query, check the expected output, then come back for the next rep.
Q01
Most Streamed Songs
Find top streamed songs.
Q02
Artist Popularity
Find artist with highest streams.
Q03
User Listening Time
Sum listening time by user.
Q04
Playlist Engagement
Find playlists with many songs.
Q05
Premium vs Free Users
Compare average listening time.
Q06
Daily Active Listeners
Count active listeners by day.
Q07
Repeat Listeners
Find repeat user-song listens.
Q08
Trending Songs
Compare song streams day over day.
Q09
Subscription Retention
Find consecutive subscription months.
Q10
Long Listening Sessions
Find sessions over one hour.