Problem Statement

Inside each duplicate-email group, find the record with the most recent hire_date (use employee_id DESC as a tie-breaker). Return employee_id, first_name, last_name, email, hire_date, rn — ordered by email.

Relevant Tables