Update department-highest-salary.sql

kamyu104 · kamyu104 · commit 34052c1ffd07 · 2015-01-21T22:59:54.000+08:00
diff --git a/MySQL/department-highest-salary.sql b/MySQL/department-highest-salary.sql
@@ -31,7 +31,7 @@
 # Write your MySQL query statement below
 SELECT d.Department AS Department, e.Name AS Employee, d.Salary AS Salary
 FROM (SELECT Department.Id AS DepartmentId, Department.Name AS Department, emp.Salary AS Salary
-        FROM Department JOIN (SELECT DepartmentId, MAX(Salary) AS Salary FROM Employee GROUP BY Employee.DepartmentId) emp
+        FROM Department JOIN (SELECT DepartmentId, MAX(Salary) AS Salary FROM Employee GROUP BY DepartmentId) emp
         ON Department.Id = emp.DepartmentId) d 
       JOIN Employee e 
       ON e.DepartmentId = d.DepartmentId and e.Salary = d.Salary
