Rolling 7-Day Average Meeting Duration | Dataford Interview Questions

Write a query to calculate the rolling 7-day average of meeting duration per user account for Zoom Video Communications.

Use completed meetings with non-null durations. The rolling period includes the current meeting date and the six preceding calendar days.

Output

One row per account and date with at least one qualifying meeting.
Columns: account_id, account_name, meeting_date, and rolling_avg_duration.
Round the average to two decimal places and order by account_name, then meeting_date.

zoom_accounts

Column	Type	Description
account_idPK	INT	Unique Zoom customer account identifier
account_name	VARCHAR(100)	Display name of the Zoom customer account

zoom_meetings

Column	Type	Description
meeting_idPK	INT	Unique meeting identifier
account_id	INT	Account that hosted the meeting
meeting_date	DATE	Calendar date on which the meeting occurred
duration_minutes	INT	Meeting duration in minutes
status	VARCHAR(20)	Meeting completion status

Your question is Rolling 7-Day Average Meeting Duration. Start with the requirements and the two 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.