2005 Expenses by Genre
For the quarterly report the club needs 2005 spending broken down by genre. For each genre with at least one 2005 loan, output the genre name and total spending (daily_fee * days summed across all loans of that genre). Skip genres with zero spending.
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.
| genre | total_spent |
|---|---|
| novel | 142.50 |
| biography | 126.00 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in