Update employees-earning-more-than-their-managers.sql

kamyu104 · kamyu104 · commit 5a5f2618d14a · 2015-01-16T13:36:23.000+08:00
diff --git a/MySQL/employees-earning-more-than-their-managers.sql b/MySQL/employees-earning-more-than-their-managers.sql
@@ -32,6 +32,6 @@ SELECT e.Name AS Employee  FROM Employee e LEFT JOIN Employee b
 # Write your MySQL query statement below
 SELECT Name AS Employee 
     FROM Employee e 
-    WHERE e.Salary > (SELECT Salary 
+    WHERE e.ManagerId IS NOT NULL AND e.Salary > (SELECT Salary 
                           FROM Employee 
                           WHERE e.ManagerId = Id)
