SQL Rolling Average Conversions

MediumSQL · PostgreSQL

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

Tablesdaily_conversions

CodePostgreSQL

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

Run your query to see results here.