DB Quacks SQL Tutorial · Chapter 4

No Duck LEFT Behind

Social worker duck approaches with concern. Some shy ducks never visited ponds! Our previous reports only showed swimming ducks. I want ALL ducks included, even homebodies who stayed home!

Your task

Show all ducks and their pond visits, including ducks who never visited any pond, by joining the ducks table with 'data/pond_visits.csv'. You will be ensuring no ducks are excluded from the results.

Start level 20 →

DuckDB docs for this lesson