DB Quacks SQL Tutorial · Chapter 4
When Harry Met Sally: A Table-JSON Love Story
The beaver gets excited and calls Professor Shellbert. We can connect duck visits from our database with pond locations from the JSON file! Join our pond_visits table with JSON location data!
Your task
Show duck names, pond names, visit dates, and water types by joining the 'data/pond_visits.csv' file with the 'data/pond_locations.json' file. You will be connecting data from two different file formats.