DB Quacks SQL Tutorial · Chapter 4
The Parent Trap: A JOIN Story
Gordon swims back excitedly. Species representation is perfect! Now we need pond-based festival activities where ducks share favorite swimming spots. But duck info and pond visits are in separate tables - help us connect them!
Your task
Show duck names along with their pond visit information by connecting the ducks table with the 'data/pond_visits.csv' file. You will be joining two different data sources to combine duck information with their visit records.