Compute Fitness App DAU

The dataset comes from a fitness tracking product and is stored in two tables. The users table holds one row per account, with columns user_id (BIGINT), signup_ts (TIMESTAMP), timezone (VARCHAR) and is_test_user (BOOLEAN). The app_events table records individual product interactions, with columns event_id (BIGINT), user_id (BIGINT), event_ts (TIMESTAMP) and event_name (VARCHAR); app_events.user_id references users.user_id. Treat an account as active on a given UTC calendar…