solve problem Employees Earning More Than Their Managers

P-ppc · P-ppc · commit bbe76fe31db6 · 2018-11-23T22:05:59.000+08:00
diff --git a/README.md b/README.md
@@ -329,4 +329,5 @@ All solutions will be accepted!
 |627|[Swap Salary](https://leetcode-cn.com/problems/swap-salary/description/)|[mysql](./database/SwapSalary)|Easy|
 |175|[Combine Two Tables](https://leetcode-cn.com/problems/combine-two-tables/description/)|[mysql](./database/CombineTwoTables)|Easy|
 |183|[Customers Who Never Order](https://leetcode-cn.com/problems/customers-who-never-order/description/)|[mysql](./database/CustomersWhoNeverOrder)|Easy|
-|197|[Rising Temperature](https://leetcode-cn.com/problems/rising-temperature/description/)|[mysql](./database/RisingTemperature)|Easy|
+|197|[Rising Temperature](https://leetcode-cn.com/problems/rising-temperature/description/)|[mysql](./database/RisingTemperature)|Easy|
+|181|[Employees Earning More Than Their Managers](https://leetcode-cn.com/problems/employees-earning-more-than-their-managers/description/)|[mysql](./database/EmployeesEarningMoreThanTheirManagers)|Easy|
diff --git a/database/EmployeesEarningMoreThanTheirManagers/README.md b/database/EmployeesEarningMoreThanTheirManagers/README.md
@@ -0,0 +1,2 @@
+# Employees Earning More Than Their Managers
+We can solve this problem by join
diff --git a/database/EmployeesEarningMoreThanTheirManagers/solution.sql b/database/EmployeesEarningMoreThanTheirManagers/solution.sql
@@ -0,0 +1,4 @@
+# Write your MySQL query statement below
+select l.Name as Employee from Employee as l
+    join Employee as r
+    on l.ManagerId = r.Id and l.Salary > r.Salary

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+# Employees Earning More Than Their Managers`
	`2`	`+We can solve this problem by join`