Scenario SQL Question
Calculate 7-Day Rolling Average Revenue
Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.
Problem Statement
Write a query to calculate the 7-day rolling average of daily sales revenue for 2024. Return order_date, daily_revenue, and rolling_avg_7days.
Relevant Tables
orders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: