Problem Statement

Inside each duplicate-email group, assign a row number 1..N based on employee_id ascending. Return employee_id, first_name, last_name, email, rn — ordered by email then rn so each duplicate group is shown together.

Relevant Tables