Pro exercise

Combine overlapping exports

Two customer exports overlap: the latest export and an older archive. Stack them with lineage, keep one row per customer preferring the latest export, and keep customers that only exist in the archive.

combining files
lineage
deduplication