Loading problem...
A workforce directory stores each employee and the team they belong to.
Table: employee
Task: For every employee row, return the employee_id and the number of employees in that same team.
Output requirements:
Supported submission environments:
employee:
| employee_id | team_id |
|-------------|---------|
| 1 | 8 |
| 2 | 8 |
| 3 | 8 |
| 4 | 7 |
| 5 | 9 |
| 6 | 9 |[
{"employee_id":1,"team_size":3},
{"employee_id":2,"team_size":3},
{"employee_id":3,"team_size":3},
{"employee_id":4,"team_size":1},
{"employee_id":5,"team_size":2},
{"employee_id":6,"team_size":2}
]Team 8 has three members (1,2,3), team 7 has one member (4), and team 9 has two members (5,6).
employee:
| employee_id | team_id |
|-------------|---------|
| 10 | 50 |
| 20 | 50 |
| 30 | 50 |
| 40 | 50 |[
{"employee_id":10,"team_size":4},
{"employee_id":20,"team_size":4},
{"employee_id":30,"team_size":4},
{"employee_id":40,"team_size":4}
]All employees are in the same team, so each employee gets team_size = 4.
employee:
| employee_id | team_id |
|-------------|---------|
| 100 | 1 |
| 200 | 2 |
| 300 | 3 |[
{"employee_id":100,"team_size":1},
{"employee_id":200,"team_size":1},
{"employee_id":300,"team_size":1}
]Each employee is alone in their team, so every row has team_size = 1.
Constraints