Rolling Revenue Average

A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.

Domain
SQL
Difficulty
medium
Seniority
L5

Interview Prompt

We track every transaction on our marketplace and want a smoothed view of revenue over time. Roll revenue up by month, then report a 3-month rolling average of those monthly totals for each month, oldest to newest.

Summary

Smooth out the revenue bumps. The trend matters more.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write and run your SQL against a real database
  4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision