Netflix's pricing team is reviewing its three plans. Before changing prices, they want to know which plan loses the most subscribers, how quickly, and why. A subscription is cancelled when it has an end_date.
Count all subscriptions for each plan, showing the plan's name.
Expected output
Example of the shape (made-up values):
| plan_name | subscriptions |
|---|---|
| Basic | 190 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.