DB Quacks SQL Tutorial · Chapter 6
The Lord of the Rings: ROLLUP of Power
Gandalf the Grey Duck appears with a glowing staff. One report to rule them all! The Council needs visit counts by species AND pond, plus subtotals by species, AND grand total. Use ancient ROLLUP magic!
Your task
Create a hierarchical report showing visit counts with subtotals by species and a grand total by joining the ducks table with 'data/pond_visits.csv'. You will be creating multiple levels of aggregation.