Rolling Revenue Average

A hard SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

Compute a 3-month rolling average of total revenue from transactions, excluding refunds (negative amounts). For each month, the average uses the current month and the two preceding months. Show year-month in YYYY-MM format and the rolling average, sorted chronologically. The first two months will not be true 3-month averages.

Summary

Smooth out the revenue bumps. The trend matters more.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.