Churned Subscribers in a Month

Return the number of subscribers whose subscription ended during September 2026 (end_date in that month).

Table schema

Subscriptions(id INT PRIMARY KEY, user_id INT, start_date DATE, end_date DATE NULL)

Sample data

id | user_id | start_date | end_date
1 | 1 | 2026-01-01 | NULL
2 | 2 | 2026-05-01 | 2026-09-30
3 | 3 | 2026-09-01 | 2026-12-31