Scenario SQL Question

Employees with Same Job Title

Build mastery in Joins with this scenario-based SQL challenge and live execution support.

Problem Statement

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.

Relevant Tables

employeesjobs

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

INNER JOIN Deep DiveJoins & Relationships
LEFT/RIGHT/FULL OUTER JOINJoins & Relationships
Multiple Table JoinsJoins & Relationships