Interview Query

Daily Active Users

17
Have you seen this question before?

Given a table of user logs with platform information, count the number of daily active users on each platform for the year of 2020.

Example:

Input:

events table

Column Type
id INTEGER
user_id INTEGER
created_at DATETIME
action VARCHAR
url VARCHAR
platform VARCHAR

Output:

Columns Type
platform VARCHAR
created_at DATETIME
daily_users INTEGER
Next question: Mutated Offspring
.....
MySQL 8.0.17
Loading editor
Use Shift + Enter to run query