7-Day Rolling Active Users

StreamWave tracks user activity across its app and wants a daily engagement trend. Write a SQL query to calculate the 7-day rolling average of daily active users.

A user is considered active on a given date if they generated at least one event that day. Use the event log and return one row per calendar date present in the data.

Requirements

1. Count distinct active users per day from the user_events table.
2. Calculate the 7-day rolling average of daily active users, ordered by event date.
3. Include dates even when user_id is NULL; those rows should not count toward active users.
4. Return the columns event_date, daily_active_users, and rolling_7_day_avg.
5. Order the final result by event_date ascending.

Table Definitions

user_events