Leetcode Mysql 1303. 求团队人数（DAY 3）

原题题目

代码实现（首刷自解）

# Write your MySQL query statement below
SELECT employee_id,team_size
FROM employee e,(SELECT team_id,count(*) team_size FROM employee GROUP BY team_id) t
WHERE e.team_id = t.team_id;