Daily Active Users — Solution & ExplanationProblems / Daily Active Users / EditorialApproach

Group by date: Group the events table by event_date.

Count distinct users: Use COUNT(DISTINCT user_id) to count unique active users per day.

Order: Sort by date ascending.

Key ConceptCOUNT(DISTINCT ...) eliminates duplicate values before counting, giving us the number of unique users who had at least one event on each day.Hints

Use COUNT(DISTINCT user_id) to count unique users per day.

Group by event_date and order the results chronologically.

Solve Daily Active Users yourself →