Table name: web_events
Columns:
session_id – primary key, there is one row per session
session_ts – timestamp of the beginning of session
user_id – user id
experiment_ids – list of experiment ids that the user is exposed to in a given session (separated by pipe delimiter) e.g ExpA | ExpB | ExpE
This table goes back several years and is current as of yesterday. Write SQL to:
1) For the month of August 2016, how many unique users per day were there? Output: date, user count
2) For the month of August 2016, what was the average number of unique users per day?
1 Answers
Your Answer