Scenario SQL Question
Monthly Revenue Summary (Portable Month Bucketing)
Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.
Problem Statement
Summarize total revenue and order count per calendar month across all data. Return order_month (as 'YYYY-MM'), order_count, monthly_revenue — ordered by order_month.
Relevant Tables
orders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: