THE CLOUD EXPEDITION! · Chapter 1
The Bridge Over Troubled Data
Marina Webfoot surfaces with a splash, barely containing herself. Local data on your machine, travel records in the cloud — and you can JOIN them in ONE query?! She looks at you wide-eyed. Lets find out where our Pondville ducks have ACTUALLY been going! This is a Hybrid Query — joining local and cloud tables seamlessly.
Your task
Find where Pondville ducks have been traveling. Return their <b>name</b>, <b>destination_pond</b>, and <b>travel_date</b> — most recent trips first, 10 rows. Tables: `pondville_residents` (local), `dbquacks_cloud_expedition.duck_travels` (MotherDuck). The tables share a `duck_id` column.