Write a PostgreSQL query against voa_budget_lines to show total 2024 budget amount by program_name. Exclude rows where program_name is NULL or an empty string, and sort by total amount descending, then program name ascending.
| Column | Type | Description |
|---|---|---|
| budget_line_id | INT | Unique budget line identifier |
| program_name | VARCHAR(100) | Program tied to the budget line |
| fiscal_year | INT | Fiscal year of the budget entry |
| amount | DECIMAL(12,2) | Budgeted amount |
| fund_code | VARCHAR(20) | Funding source code |
| 101 | Supportive Housing | 2024 | 12500.00 | HUD |
| 103 | Supportive Housing | 2024 | 4300.00 | PRIVATE |
| 104 | 2024 | 1500.00 | LOCAL | |
| 107 | 2024 | 2750.00 | COUNTY | |
| 109 | Youth Services | 2024 | -200.00 | ADJUST |