THE CLOUD EXPEDITION! · Chapter 2
Hot Duck Summer
Marina leans in with a competitive grin. Alright hotshot — which of our ducks are the sun-chasers? The ones who LEFT home for warmer waters? She crosses her wings. Youll need to join four tables — the global pond registry shows up twice — to crack this. Think you can handle it? This calls for Multi-Table Joins — chaining multiple joins across local and cloud tables.
Your task
Which ducks chased warmer weather? Find Pondville ducks whose travel destination was warmer than their home pond. Return <b>name</b>, <b>home_temp</b>, <b>dest_temp</b>, and <b>destination_pond</b> — biggest temperature upgrades first, 10 rows. Tables: `pondville_residents` (local, has `home_pond`), `dbquacks_cloud_expedition.duck_travels` (cloud, links ducks to destinations), `dbquacks_cloud_expedition.global_ponds` (cloud, has `avg_temperature` for each `pond_name`).