Employee Hierarchy Levels

Using a recursive CTE, return every employee with their level in the hierarchy (the top employee with no manager is level 0). Return id, name and level ordered by level.

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 | Manager | 2
4 | Dev | 3