7-Day Rolling Average Exports

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is 7-Day Rolling Average Exports. Start with the requirements and the one table on the right.

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

You need to log in / sign up to run or submit.

Problem

Adobe Acrobat product analytics wants to smooth daily export volume so the team can spot trends without day-to-day noise. Write a SQL query to calculate the 7-day rolling average of document exports per user.

Requirements

Aggregate exports to one row per user per export date.
Compute a 7-day rolling average of daily exports for each user using a window function.
Include only dates where the rolling average can be calculated from the available history in the table.
Return the result ordered by user and date.

Schema

acrobat_document_exports

Column	Type	Description
export_idPK	INT	Primary key for each export event
user_id	INT	Adobe Acrobat user identifier
export_date	DATE	Date the document was exported
document_id	INT	Identifier of the exported document
export_format	VARCHAR(20)	Export format such as PDF or DOCX

Tablesacrobat_document_exports

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results