Identifying correct SQL to compute team sizes per employee

Consider a table Employee(EmpID, TeamID), where the column EmpID (ID of an employee) is the primary key. The column TeamID denotes the team ID of the team of which the employee is a member. TeamID is a NOT NULL column. We want to display the size of the team (denoted as TeamSize) in which each employee is a member by using SQL. As an example, the desired output for the given Employee table is also shown in tabular form. Which of the following is/are correct?

| EmpID | TeamID | |—|—| | 1 | 8 | | 2 | 8 | | 3 | 8 | | 4 | 7 | | 5 | 7 | | 6 | 9 |

| EmpID | TeamSize | |—|—| | 1 | 3 | | 2 | 3 | | 3 | 3 | | 4 | 2 | | 5 | 2 | | 6 | 1 |