Your question is Monthly Reporting Package Totals. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
You are asked to summarize completed financial reporting packages prepared during 2024. Return one row per reporting month with the number of completed packages and the total hours spent preparing them, ordered by month ascending.
| Column | Type | Description |
|---|---|---|
| package_id | INT | Unique package record ID |
| package_name | VARCHAR(100) | Reporting package name |
| reporting_period_end | DATE | End date of reporting period |
| package_status | VARCHAR(20) | Package status |
| package_hours | DECIMAL(6,2) | Preparation hours |