DB Quacks SQL Tutorial · Chapter 2
Birds of a Feather GROUP Together
Goose Gordon swims up wearing a tiny campaign hat. Duckbert! Were organizing Pondvilles first Data Festival where every species gets fair representation! Professor Shellbert nods encouragingly. We need accurate species counts so every group gets a voice in planning. Can you help organize our citizen registry?
Your task
Count how many ducks of each species exist in the ducks table. You will be grouping the data by species and counting each group.