mediumPetronas · date-timePro
Monthly fuel sales
Petronas wants fuel sales rolled up by month.
From the sales table, return the first day of each month as month_start (a date) and the total amount for that month as total_sales.
Schema
▸sales
| id | INT |
| sale_date | DATE |
| amount | NUMERIC(10,2) |
Pro
The example input, expected output, and walkthrough for this question unlock with a Pro plan.
Pro
This is a Pro question
Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.