We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent 91a9972 commit 229031cCopy full SHA for 229031c
MySQL/employees-earning-more-than-their-managers.sql
@@ -1,13 +1,13 @@
1
# Time: O(n^2)
2
# Space: O(1)
3
4
-SELECT e.Name AS Employee FROM Employee e LEFT JOIN Employee b
5
- ON e.ManagerId=b.Id
6
- WHERE e.Salary > b.Salary
7
-
8
-SELECT Name AS Employee
9
- FROM Employee e
10
- WHERE e.ManagerId IS NOT NULL AND e.Salary > (SELECT Salary
11
- FROM Employee
12
- WHERE e.ManagerId = Id)
+SELECT e.Name AS Employee FROM Employee e LEFT JOIN Employee b
+ ON e.ManagerId=b.Id WHERE e.Salary > b.Salary
+
+/** # Write your MySQL query statement below **/
+ /** solution two **/
+SELECT e.name AS employee
+FROM employee AS e JOIN employee AS e1 ON e.managerid = e1.id
+WHERE e.salary > e1.salary;
13
0 commit comments