Member Spending in 2005

#97

The book club wants to know who was the most active reader in 2005. For each member, compute total spending on book loans that year (cost of one loan = daily_fee * days). Exclude members who had no loans in 2005. Sort by spending descending.

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.

costs	member_name
70.00	Oliver Whitlock
68.00	Margaret Whitlock
40.00	Walter Foster

Your query result will appear here