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

This Pro challenge keeps its schema, dataset and solution behind subscription access. No protected answer content is included in public SEO data.