THE CLOUD EXPEDITION! · Chapter 2
Crunching the Cloud
Dr. Velocity makes an early cameo, slamming open the door with a clipboard. Enough peeking at 10 rows — lets see what this cloud can REALLY do! She taps a chart showing migration routes across continents. Aggregate the ENTIRE global migrations table. No LIMIT. Let MotherDuck flex. Time for Cloud Aggregations — summarizing large cloud datasets with GROUP BY.
Your task
Which ponds send out the most migration flocks? Summarize by origin pond — show the <b>origin_pond</b>, flight count (<b>total_flights</b>), and average flock size rounded to 2 decimals (<b>avg_flock_size</b>). Busiest ponds first. Table: `dbquacks_cloud_expedition.global_migrations` (MotherDuck).