THE CLOUD EXPEDITION! · Chapter 6
Spot the Difference
Marina bursts in, eyes blazing. The storm changed EVERYTHING — but which districts got hit hardest? Chronos raises a feathered brow. Compare then and now. The data will confess what the storm tried to hide. This is Version Comparison — diffing two snapshots of the same table to find what changed.
Your task
Compare the pre-storm census (version 1) with the current data. For each district, show <b>district</b>, <b>pop_before_storm</b>, <b>pop_after_storm</b>, and <b>population_change</b> (the difference). Biggest absolute changes first. Table: `dbquacks_living_lake.pond_census` (Ducklake — version 1 is the pre-storm snapshot, current version is post-storm).