Scenario SQL Question
Cumulative Sum with Monthly Reset
Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.
Problem Statement
Show each order with a running revenue total that RESETS at the start of every month. Return order_date, order_total, cumulative_amount_month — ordered by order_date.
Relevant Tables
orders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: