SQL from plain English
ProblemSimple business questions wait days in the data team's queue because nobody else can write SQL.
BigQuery · monthly active users for 2026 · events(user_id, event_name, event_ts)
MAU = distinct users with any event in the calendar month (UTC).
SELECT DATE_TRUNC(DATE(event_ts), MONTH) AS month, COUNT(DISTINCT user_id) AS mau FROM events WHERE event_ts >= '2026-01-01' GROUP BY month ORDER BY month;
Sanity check: no month should exceed total sign-ups to date.
Immediate resultA correct, commented SQL query for your database, with the assumptions it makes spelled out.


