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_num | orders_cnt | revenue_total |
|---|---|---|
| 1 | 2 | 200.5 |
| 2 | 3 | 256 |
| 3 | 1 | 99.99 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in