# $1303. 求团队人数
# https://leetcode-cn.com/problems/find-the-team-size/

# SQL架构
Create table If Not Exists Employee (employee_id int, team_id int);
Truncate table Employee;
insert into Employee (employee_id, team_id) values ('1', '8');
insert into Employee (employee_id, team_id) values ('2', '8');
insert into Employee (employee_id, team_id) values ('3', '8');
insert into Employee (employee_id, team_id) values ('4', '7');
insert into Employee (employee_id, team_id) values ('5', '9');
insert into Employee (employee_id, team_id) values ('6', '9');

# Write your MySQL query statement below
select
    employee_id,
    count(*) over (partition by team_id) as team_size
from
    Employee;

# clean-up
drop table Employee;