SQL Rolling Average Conversions | Dataford Interview Questions

How would you use SQL to calculate a 7-day rolling average of daily conversions?

Assume the daily_conversions table contains one row per calendar date. Treat a NULL conversion count as zero and return all available dates.

Output

One row per calendar date with conversion_date, daily_conversions, and rolling_7_day_avg
Include the current date and up to the six preceding dates in each average
Order by conversion_date ascending

daily_conversions

Column	Type	Description
conversion_datePK	DATE	Calendar date for the daily conversion count
conversions	INT	Number of conversions recorded on the date

Your question is SQL Rolling Average Conversions. Start with the requirements and the one table 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.

How would you use SQL to calculate a 7-day rolling average of daily conversions?

Assume the daily_conversions table contains one row per calendar date. Treat a NULL conversion count as zero and return all available dates.

One row per calendar date with conversion_date, daily_conversions, and rolling_7_day_avg
Include the current date and up to the six preceding dates in each average
Order by conversion_date ascending

daily_conversions

Column	Type	Description
conversion_datePK	DATE	Calendar date for the daily conversion count
conversions	INT	Number of conversions recorded on the date

Your question is SQL Rolling Average Conversions. Start with the requirements and the one table 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.