Pairs of Employees with the Same Job Title

Exercise brief

Understand the request

Talent mobility analyst A peer programme needs each pair of employees sharing a job, without mirrored or self-pairs.

Find every UNIQUE pair of employees who share the same job title (each pair listed once, not twice). Return employee1_id, employee1_first_name, employee1_last_name, employee2_id, employee2_first_name, employee2_last_name, job_title — ordered by job_title, employee1_id, employee2_id.

Data you will use

Review the relevant tables before deciding how to join, filter, or aggregate them.

Hints, when you need them

Open one clue at a time so you still do the reasoning.

Verified SQL answer

Attempt the problem first, then compare structure and reasoning—not just syntax.

SELECT e1.employee_id AS employee1_id, e1.first_name AS employee1_first_name, e1.last_name AS employee1_last_name, e2.employee_id AS employee2_id, e2.first_name AS employee2_first_name, e2.last_name AS employee2_last_name, j.job_title FROM employees e1 INNER JOIN employees e2 ON e1.job_id = e2.job_id AND e1.employee_id < e2.employee_id INNER JOIN jobs j ON e1.job_id = j.job_id ORDER BY j.job_title, e1.employee_id, e2.employee_id;

Expected result

Use this output to verify values, aliases, ordering, and row count.