Active Subscribers per Month

Each subscription is active from start_month to end_month inclusive. Return the number of active subscribers for every month in which at least one subscription is active. Order by month.

Table schema

Subscriptions(user_id INT, start_month VARCHAR(7), end_month VARCHAR(7))

Sample data

user_id | start_month | end_month
1 | 2026-01 | 2026-03
2 | 2026-02 | 2026-02