Daily Active Users
Start Timer
0:00:00
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 |
.
.
.
.
.
.
.
.
.
Comments