12 SQL practice questions in our Spotify collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
1 Easy · 6 Medium · 5 Hard
Independent practice resource. Not affiliated with or endorsed by Spotify.
These topics come from the questions in this set. Pick one to open the matching problems.
Find the top 5 artists by count of song appearances in featured (is_featured = TRUE) playlists. Return artist_id, artist_name, song_count, and song_titles (comma-separated, alphabetical). Order by song_count descending (break ties alphabetically by artist name).
Calculate cumulative play count for each premium user by day in March 2026. Return user_id, stream_date, daily_play_count, and cumulative_play_count. Order by user_id, stream_date.
Find active premium subscribers who streamed songs from at least 15 different artists in the last 30 days (from March 29, 2026). Return user_id, subscription_status, artist_count, and total_minutes_streamed. Order by artist_count descending.
12 Spotify problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Your dataset
playlist_id (INTEGER) · song_id (INTEGER) · date_added (DATE) · position_in_playlist (INTEGER)
song_id (INTEGER) · artist_id (INTEGER) · title (VARCHAR) · release_date (DATE)
artist_id (INTEGER) · name (VARCHAR)
playlist_id (INTEGER) · name (VARCHAR) · playlist_type (VARCHAR) · is_featured (BOOLEAN)
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice Spotify SQL free188 SQL practice questions. 23 companies. Free access to every problem.