Daily Active Users (DAU)

Unsolved

For each calendar date present in the activity logs, count the number of distinct users who performed at least one action on that date. Return columns `activity_date` and `active_users`. Order by `activity_date` descending (most recent date first).

Learn the concept: Date FunctionsGROUP BY

SQL Query Editor (Ctrl+Enter to run)

0 characters · Valid

Canonical Solution Official

Official Solution is Hidden

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Community Q&A & Discussion

Ask questions, share alternate queries, and explore solutions

0 comments

Asked By:

🏢 Google

Submission History

Your recent query executions and answer checks

Execution Pipeline:

FROM user_activity_logs

Full source dataset

11 rows total

Reveal Canonical Solution?

This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.

Daily Active Users (DAU)

Official Solution is Hidden

Approach & Explanation

Community Q&A & Discussion

Submission History