Update # 1303. Find the Team Size.sql

Qian-Yu-2020 · web-flow · commit f496a27f90f9 · 2020-12-10T23:55:01.000-05:00
diff --git a/Schools and Organizations/# 1303. Find the Team Size.sql b/Schools and Organizations/# 1303. Find the Team Size.sql
@@ -15,8 +15,8 @@ FROM Employee e
 ;
 
 
-
-# Use LEFT JOIN to self-join; Don't forgot to use GROUP BY 
+# Use SELF-JOIN; Don't forgot to use GROUP BY 
+# Why need 2 tables - It's basically used where there is any relationship between rows stored in the same table (correlate pairs of rows from the same table)
 select e1.employee_id,count(*) team_size
 		from employee e1 left join employee e2on e1.team_id = e2.team_id
 group by e1.employee_id;

Original file line number	Diff line number	Diff line change
`@@ -15,8 +15,8 @@ FROM Employee e`
`15`	`15`	`;`
`16`	`16`
`17`	`17`
`18`		`-`
`19`		`-# Use LEFT JOIN to self-join; Don't forgot to use GROUP BY`
< 4DEB code>	`18`	`+# Use SELF-JOIN; Don't forgot to use GROUP BY`
	`19`	`+# Why need 2 tables - It's basically used where there is any relationship between rows stored in the same table (correlate pairs of rows from the same table)`
`20`	`20`	`select e1.employee_id,count(*) team_size`
`21`	`21`	`from employee e1 left join employee e2on e1.team_id = e2.team_id`
`22`	`22`	`group by e1.employee_id;`