Count Descendants of Each Employee

For every employee return the number of direct and indirect reports. Order by 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 | Mgr | 2
4 | Dev1 | 3
5 | Dev2 | 3