logo

Oracle NextGen

score

SQL Challenge

Challenge #9 – Employee Managers

MediumGo Back
Challenge Overview
List all employees along with their manager's name. Show employees who have a manager.

Requirements

  • •Return columns: employee_name, manager_name.
  • •Use a self-join on the employees table.
  • •Exclude employees with no manager (CEO).
  • •Order by employee_name alphabetically.
Sample Dataset
Preview the schema and seeded rows you can query against.

employees

Employee hierarchy.

Columns
NameTypeNotes
employee_idINTPrimary key
employee_nameVARCHAREmployee name
manager_idINTManager's employee_id
Sample Rows
employee_idemployee_namemanager_id
1Alice
2Bob1
3Charlie1
4David2
5Eve2
SQL Playground
Loading editor…

Result Preview

Awaiting Run

Run your query to see the dataset preview.