SQL for Monthly Active Users

Glassdoor wants to monitor engagement across its Jobs, Reviews, and Community experiences. Write a PostgreSQL query to calculate monthly active users, where an active user is an active Glassdoor member who generated at least one qualifying activity event during that calendar month.

Requirements

1. Include only members whose account_status is active.
2. Treat page_view, job_search, application, and review_view as qualifying events.
3. Count each member once per calendar month, even when they generate multiple events.
4. Return the month as YYYY-MM, the monthly active user count, and sort chronologically.