Agent View

-- Synthetic PostgreSQL reference, not an AI benchmark. -- Run the complete file in one disposable local session. Temporary tables only. CREATE TEMP TABLE context_users (user_id integer PRIMARY KEY, region text NOT NULL, is_test boolean NOT NULL); CREATE TEMP TABLE context_events (event_id integer PRIMARY KEY, user_id integer REFERENCES context_users, event_type text NOT NULL, occurred_at timestamptz NOT NULL); INSERT INTO context_users VALUES (1,'North',false),(2,'North',false),(3,'South',false),(4,'South',true),(5,'West',false); INSERT INTO context_events VALUES (101,1,'project_created','2026-09-03 10:00:00+00'), (102,1,'report_exported','2026-09-04 10:00:00+00'), (103,2,'login','2026-09-05 10:00:00+00'), (104,3,'project_created','2026-09-01 00:00:00+00'), (105,4,'project_created','2026-09-06 10:00:00+00'), (106,2,'project_created','2026-10-01 00:00:00+00'), (107,2,'project_created','2026-08-31 23:59:59+00'), (108,NULL,'report_exported','2026-09-07 10:00:00+00'); -- Q1: Distinct non-test users with qualifying activity in September UTC. Expected 2. SELECT COUNT(DISTINCT u.user_id) AS active_users FROM context_users AS u JOIN context_events AS e ON e.user_id = u.user_id WHERE u.is_test = false AND e.event_type IN ('project_created', 'report_exported') AND e.occurred_at >= TIMESTAMPTZ '2026-09-01 00:00:00+00' AND e.occurred_at < TIMESTAMPTZ '2026-10-01 00:00:00+00'; -- Q2: Same definition by current user region, including regions with zero. North 1, South 1, West 0. SELECT u.region, COUNT(DISTINCT e.user_id) AS active_users FROM context_users AS u LEFT JOIN context_events AS e ON e.user_id = u.user_id AND e.event_type IN ('project_created', 'report_exported') AND e.occurred_at >= TIMESTAMPTZ '2026-09-01 00:00:00+00' AND e.occurred_at < TIMESTAMPTZ '2026-10-01 00:00:00+00' WHERE u.is_test = false GROUP BY u.region ORDER BY u.region; -- Q3: Only report exporters; retain September UTC, non-test users and zero regions. North 1, South 0, West 0. SELECT u.region, COUNT(DISTINCT e.user_id) AS active_users FROM context_users AS u LEFT JOIN context_events AS e ON e.user_id = u.user_id AND e.event_type = 'report_exported' AND e.occurred_at >= TIMESTAMPTZ '2026-09-01 00:00:00+00' AND e.occurred_at < TIMESTAMPTZ '2026-10-01 00:00:00+00' WHERE u.is_test = false GROUP BY u.region ORDER BY u.region;