Employees and Their Managers' Names
Easy
Joins
Return each employee's name with their manager's name (NULL for the top manager). Order by employee id.
Table schema
Employees(id INT PRIMARY KEY, name VARCHAR(50), manager_id INT NULL)Sample data
id | name | manager_id
1 | CEO | NULL
2 | VP | 1
3 | Dev | 2
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.