Pro exercise

Prefer the most complete record

Contacts are duplicated by email. Keep the record that has a phone number; among those, the most recently updated one; then the smallest id. Report the others as merged duplicates.

deduplication
survivor rules
completeness