Last updated on October 9th, 2024 at 10:02 pm

This Leetcode problem Find the Team Size LeetCode Solution is done in SQL.

List of all LeetCode Solution

Find the Team Size LeetCode Solution

Problem Statement

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 result format is in the following example.

Example 1:
Input:

Output:

1. Find the Team Size LeetCode Solution MySQL

select 
  employee_id, 
  team_size 
from 
  Employee as e 
  join (
    select 
      team_id, 
      count(*) as team_size 
    from 
      employee 
    group by 
      team_id
  ) as t on e.team_id = t.team_id;