Write SQL for 7-day geo-localized revenue dashboard

Using PostgreSQL, produce one SQL statement that builds a seven-day activity dashboard, split by the user's local calendar day and grouped into US versus Asia. Set the reference date to 2025-09-01; therefore the covered local dates are 2025-08-26 through 2025-09-01, both ends included. A user's local date is obtained by adding tz_offset hours to event_time_utc. The result must contain these columns: local_date, region_group (either US or Asia), dau, buyers, revenue_usd,…