1303_Find_the_Team_Size.sql

SELECT e1.employee_id, COUNT(*) AS team_size
FROM Employee e1
JOIN Employee e2 
ON e1.team_id = e2.team_id
GROUP BY e1.employee_id;