Employee Manager Lookup

Use a self LEFT JOIN to list every employee with their direct manager's first name. Return columns: id, first_name, manager_name. Order results by: e.id.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Use a self LEFT JOIN to list every employee with their direct manager's first name. Return columns: id, first_name, manager_name. Order results by: e.id.

Difficulty: Expert
SQL concept: LEFT JOIN