SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE empleados ([id] int, [id_manager] int, [nombre] nvarchar(30), [nombre_manager] nvarchar(30)) ; INSERT INTO empleados ([id] , [id_manager], [nombre], [nombre_manager]) VALUES (1, null, 'Fredi', null), (2, 1, 'Mafi', 'Fredi'), (3, 1, 'Diego', 'Fredi'), (4, 2, 'Sofy', 'Mafi'), (5, 4, 'Tomy', 'Sofy') ; SELECT * FROM empleados; With Managers(id_manager,nombre_manager) AS ( SELECT DISTINCT id_manager, nombre_manager FROM empleados WHERE id_manager IS NOT NULL ) SELECT E.id_manager,COUNT(E.nombre) FROM empleados AS E INNER JOIN Managers AS M ON E.id = M.id_manager WHERE M.id_manager <= E.id;