Average Meetings per User per Day | Dataford Interview Questions

Using the same User / Meeting / Activity tables, write a SQL query to compute the average number of meetings attended per day across all users in the past one month.

Asked in the phone screen stage. Problem #1b.

Output

One row per date represented by a meeting in the period.
Columns: Date, Average Number of Meetings.
Include all users in each daily average, including users with no attended meetings.
Sort by Date ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique Zoom user identifier
email	VARCHAR(255)	User email address

meetings

Column	Type	Description
meeting_idPK	INT	Unique meeting identifier
organizer_id	INT	User who organized the meeting
meeting_title	VARCHAR(255)	Meeting title
started_at	TIMESTAMP	Meeting start timestamp

activities

Column	Type	Description
activity_idPK	INT	Unique activity identifier
meeting_id	INT	Referenced meeting
user_id	INT	User who generated the activity
activity_type	VARCHAR(50)	Activity status such as attended, joined, or declined

Your question is Average Meetings per User per Day. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem