Scenario SQL Question
Calculate Month-To-Date (MTD) Revenue
Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.
Problem Statement
For December 2024, show each order day's revenue and the running month-to-date total. Return order_date, daily_revenue, mtd_revenue — ordered by order_date.
Relevant Tables
orders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: