Commitfa5f401

committed

add 1371

1 parent9486281 commitfa5f401Copy full SHA for fa5f401

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1116,6 +1116,7 @@ _If you like this project, please leave me a star._ ★`
`1116`	`1116`	`\|1393\|[Capital Gain/Loss](https://leetcode.com/problems/capital-gainloss/)\|[Solution](../master/database/_1393.sql)\|\| Easy\|`
`1117`	`1117`	`\|1384\|[Total Sales Amount by Year](https://leetcode.com/problems/total-sales-amount-by-year/)\|[Solution](../master/database/_1384.sql)\|\| Hard\|`
`1118`	`1118`	`\|1378\|[Replace Employee ID With The Unique Identifier](https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/)\|[Solution](../master/database/_1378.sql)\|\| Easy\|`
	`1119`	`+\|1371\|[The Number of Employees Which Report to Each Employee](https://leetcode.com/problems/the-number-of-employees-which-report-to-each-employee/)\|[Solution](../master/database/_1371.sql)\|\| Easy\|`
`1119`	`1120`	`\|1369\|[Get the Second Most Recent Activity](https://leetcode.com/problems/get-the-second-most-recent-activity/)\|[Solution](../master/database/_1369.sql)\|\| Hard\|`
`1120`	`1121`	`\|1364\|[Number of Trusted Contacts of a Customer](https://leetcode.com/problems/number-of-trusted-contacts-of-a-customer/)\|[Solution](../master/database/_1364.sql)\|\| Medium\|`
`1121`	`1122`	`\|1355\|[Activity Participants](https://leetcode.com/problems/activity-participants/)\|[Solution](../master/database/_1355.sql)\|\| Medium\|`

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,5 @@`
	`1`	`+--# Write your MySQL query statement below`
	`2`	`+selectb.employee_id,b.name,count(*)as reports_count, round(avg(a.age))as average_age`
	`3`	`+from Employees ajoin Employees bona.reports_to=b.employee_id`
	`4`	`+group byb.employee_id`
	`5`	`+order byb.employee_id`

Comments

(0)