Spotify SQL interview questions
Listening behaviour — streams, playlists and retention. Practice reconstructed Spotify-style SQL, Python and pandas interview questions below — run and grade them instantly in your browser.
sqlpythonpandaseasy1medium4hard4
typical interview loop
- 1.Recruiter screen
- 2.Technical screen: 2–3 SQL questions in a shared editor (~45 min)
- 3.Onsite: SQL / Python coding, product-sense metrics case, behavioral
- › Sessionisation and top-N tracks per user come up.
most-tested topics
GROUP BY
3
JOIN
2
ratios
2
CASE
2
groupby
2
strings
1
Based on 9 reconstructed Spotify-style questions.
practice path
1 free · 8 Protype
level
- 1Plays per genresqleasy
- 2Completion rate per tracksqlmedium
- 3Deduplicate playlist trackspythonmedium
- 4Listener depth bucketssqlmedium
- 5Monthly listening hours per artistpandasmedium
- 6Each user's most played artistsqlhard
- 7Pro-rata royalty payoutspandashard
- 8Recommendation skip and save ratessqlhard
- 9Skip rate per userpandashard
Unlock all 9 Spotify questions with Pro.
upgrade