DB Quacks SQL Tutorial · Chapter 7
Endgame - Data Assembly
Festival day arrives! All your Pondville friends gather at the floating festival stage. Duckbert! calls Professor Shellbert. Ducks are arriving from everywhere - families reuniting, interdimensional visitors, cloud communities! We need perfect timing coordination. The Doctor Duck materializes with festival schedules. Match everyones current location with migration history for perfect arrival timi…
Your task
Use ASOF JOIN to create perfect timing by matching current duck locations from 'data/duck_locations.csv' with their migration history from 'data/migration_history.parquet'. You will be finding the most recent migration record for each duck.