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:
ac
+---------------+---------+
| 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.
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.