From a subscriptions table with user_id, plan_type, start_date, and end_date, write a query that calculates monthly recurring revenue (MRR) for each month, accounting for upgrades, downgrades, and cancellations.

Question

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

From a subscriptions table with user_id, plan_type, start_date, and end_date, write a query that calculates monthly recurring revenue (MRR) for each month, accounting for upgrades, downgrades, and cancellations.

Practice more