Level 2 - JuniorQuery-Based Questions
Monthly Revenue Report (2025)
Write SQL to show monthly revenue for year 2025 as month_number and total_revenue. Sort by month_number ascending.
Schema Context
orders(id, customer_id, total_amount, order_date)
Write SQL to show monthly revenue for year 2025 as month_number and total_revenue. Sort by month_number ascending.
orders(id, customer_id, total_amount, order_date)