1303-FindTheTeamSize.sql

/* Write your T-SQL query statement below */
SELECT
    a.employee_id, b.team_size
FROM Employee AS a
INNER JOIN (
    SELECT
        team_id,
        count(employee_id) AS team_size
    FROM Employee
    GROUP BY team_id
) AS b
    ON a.team_id  = b.team_id