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
Write a query to calculate month-to-date revenue for December 2024. Return order_date, daily_revenue, and mtd_revenue (cumulative within the month).
Relevant Tables
orders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: