SQL Interview Question | Intermediate SQL Question 21

Question - Find number of members in a team for each employee.
drop table Employee_Team
CREATE TABLE Employee_Team (
employee_id INT,
team_id INT
);
INSERT INTO Employee_Team (employee_id, team_id)
VALUES
(1, 8),
(2, 8),
(3, 8),
(4, 7),
(5, Null),
(6, 9);
select * from Employee_Team
.
.
.
.
.
.
#amazon #ai #meta #facebook #instagram #netflix #dataanalytics #sql #placement #college

[@somanathking4694]

Bro, Please post the string based scenario questions

[@somanathking4694]

with cte as

[@Savenature635]

Here is my approach :