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.
Exemplo de resposta esperada
É assim que se parece uma resposta correta: ela tem seu próprio número de linhas e não precisa coincidir com as tabelas do esquema. Sua resposta precisa retornar os mesmos nomes de colunas do exemplo: use AS para renomeá-las se for preciso.
| month_num | orders_cnt | revenue_total |
|---|---|---|
| 1 | 2 | 200.5 |
| 2 | 3 | 256 |
| 3 | 1 | 99.99 |
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
Entrar