Monthly Sales Pulse

Monthly Sales Pulse

You are an analyst at Bramble Market, a convenience store chain. The CFO is building next year's budget and wants to see the seasonality of 2025: which months sold more orders and how much revenue they brought. The store_orders table spans several years, but only 2025 matters here. For every month of 2025 that has at least one order, count the orders and total the revenue. Months without orders must not appear. Return columns: - month_num — month number (integer 1 to 12); - orders_cnt — number of orders in that month (integer); - revenue_total — total revenue of the month, rounded to 2 decimals. Sort by month_num ascending. Orders from other years are ignored entirely; the data contains no duplicate orders.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.

month_numorders_cntrevenue_total
12200.5
23256
3199.99
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid