THE CLOUD EXPEDITION! · Chapter 7
The Hundred-Million Row March
A duck in a lab coat skids to a halt — Dr. Velocity! Forget toy datasets, Duckbert. Were about to crunch 100 MILLION migration records! She slams a comically oversized calculator on the table. MotherDuck eats big data for breakfast. Time for Cloud Scale Analytics — aggregating massive datasets in the cloud.
Your task
Break down migration patterns by year and season. For each period, show <b>migration_year</b>, <b>migration_season</b>, flight count (<b>total_flights</b>), average flock size rounded to 2 decimals (<b>avg_flock_size</b>), and average distance rounded to 2 decimals (<b>avg_distance</b>). Order chronologically by year, then season. Table: `dbquacks_cloud_expedition.global_migrations` (MotherDuck). Relevant columns: `flock_size`, `distance_km`.