Scenario SQL Question

Employee Hire Date Analysis with Joins

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

Problem Statement

List employees hired on or after 2021-01-01 alongside their direct manager. INNER JOIN to manager (drop top-level employees). Return employee_id, first_name, last_name, hire_date, manager_id, manager_first_name, manager_last_name, manager_hire_date — ordered by hire_date, employee_id.

Relevant Tables

employees

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