Problem Statement

Write a query to find pairs of employees who work in the same department (excluding self-pairs and avoiding duplicates). Return employee1_name, employee2_name, and department_id. Order by department and employee names.

Relevant Tables