Compute ARPDAU/ARPPU by country

You are given two tables. app_sessions holds one row per recorded session, with columns user_id (INT), session_id (VARCHAR), session_start_ts (TIMESTAMP) and country (VARCHAR). payments holds purchase records, with columns user_id (INT), session_id (VARCHAR), amount_usd (DECIMAL) and purchased_at (TIMESTAMP). Write one SQL query that returns, for every day-and-country pair whose day falls inside the window from 2025-08-26 through 2025-09-01 inclusive, these columns: dt, the…