# 1303. Find the Team Size

https://leetcode.com/problems/find-the-team-size

## Description

Table: `Employee`

```
+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| employee\_id   | int     |
| team\_id       | int     |
+---------------+---------+
employee\_id is the primary key for this table.
Each row of this table contains the ID of each employee and their respective team.
```

Write an SQL query to find the team size of each of the employees.

Return result table in any order.

The query result format is in the following example:

```
Employee Table:
+-------------+------------+
| employee\_id | team\_id    |
+-------------+------------+
|     1       |     8      |
|     2       |     8      |
|     3       |     8      |
|     4       |     7      |
|     5       |     9      |
|     6       |     9      |
+-------------+------------+
Result table:
+-------------+------------+
| employee\_id | team\_size  |
+-------------+------------+
|     1       |     3      |
|     2       |     3      |
|     3       |     3      |
|     4       |     1      |
|     5       |     2      |
|     6       |     2      |
+-------------+------------+
Employees with Id 1,2,3 are part of a team with team\_id = 8.
Employees with Id 4 is part of a team with team\_id = 7.
Employees with Id 5,6 are part of a team with team\_id = 9.
```

## ac

```java
```
