DB Quacks SQL Tutorial · Chapter 2

HAVING a Ball with Conditional Counting

Fancy duck Reginald glides over with a monocle and bow tie. Im president of the Numerous Species Club - we only accept species with more than 2 members! Find which species qualify for our exclusive club.

Your task

Show only species from the ducks table that have more than 2 members, along with their count. You will be filtering groups based on their aggregate values.

Start level 13 →

DuckDB docs for this lesson