Spotify
Interview Core Track · Hard · 35 min
Rolling Three-day Earnings
Use this Spotify planning note to work on rolling three-day earnings. Return each user_id, transaction_date, and rolling_3_day_earnings based on the current ...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a Spotify-tagged business scenario.
Approach
Use this track to improve speed, edge-case handling, and accuracy under timed conditions.
Company context
Company labels are directional practice context, not official interview guidance.
Use this Spotify planning note to work on rolling three-day earnings. Return each user_id, transaction_date, and rolling_3_day_earnings based on the current day plus the previous two transaction dates for that user. Sort by user_id and transaction_date.
This is a Pro question
Upgrade to Pro to unlock this prompt, the SQL workspace, and all 254 problems.
Upgrade to Pro — unlock all 254 problemsSQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.