DB Quacks SQL Tutorial · Chapter 4

Pond Bouncers: The WHERE-JOIN Chronicles

Security guard goose swims over with a badge. We have VIP ponds for older ducks only! Show me visits where ducks older than 3 years went to ponds. I need to verify our access rules work correctly.

Your task

Show visits where ducks older than 3 years visited ponds, combining the ducks table with 'data/pond_visits.csv' and filtering by age. You will be joining and filtering data simultaneously.

Start level 18 →

DuckDB docs for this lesson