This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Subscription Analyst at Spotify. The finance team needs a snapshot of every user's current subscription for revenue forecasting. Since users may have had multiple subscriptions over time (upgrades, downgrades, re-subscriptions), you need to retrieve only the most recent subscription per user -- the one with the latest start_date. This ensures the forecast reflects each user's current plan.
You are a Subscription Analyst at Spotify. The finance team needs a snapshot of every user's current subscription for revenue forecasting. Since users may have had multiple subscriptions over time (upgrades, downgrades, re-subscriptions), you need to retrieve only the most recent subscription per user -- the one with the latest start_date. This ensures the forecast reflects each user's current plan.