Daily Active Users and Churn

Wish wants a daily engagement report for users interacting with the Wish marketplace. Using the tables below, write a PostgreSQL query for activity from January 1 through January 5, 2025.

Requirements

1. Return one row for every date in the reporting period, including dates with no activity.
2. Calculate daily_active_users as the distinct number of registered users with at least one activity event on that date.
3. Calculate daily_churned_users as users active on the previous day who have no activity on the current day. Do not count users who were not active on the previous day.
4. Return rows ordered chronologically by activity_date.

Deduplicate multiple activity events from the same user on the same date before calculating either metric.