Daily views and unique audience
Daily views and unique audience
Lenta.ru is a news and video platform: every video view writes a single row into the log, and editorial tracks how views and the unique audience grow per day. For every date compute the total number of views and the number of unique users that day.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| watch_date | views | audience |
|---|---|---|
| 2021-01-01 | 4 | 2 |
| 2021-01-02 | 6 | 3 |
| 2021-01-03 | 4 | 3 |
Lenta
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid