mysql - SQL选择最大值

Question

我有一个如下查询:

Select Lname, MAX(HOURS)    
From (Select E.LName, SUM(Hours) as HOURS    
From WORKS_ON W    
     JOin EMPLOYEE E on E.SSN=W.ESSN    
Group by E.SSN) as hours

答案是这样的:

Lname MAX(HOURS)

Black 55

DB 55 是最大小时数的正确答案。但布莱克并不是工作55小时，而是另一个叫格兰特的人。似乎我有一个彼此不相关的答案。我应该怎么做才能得到这样的结果:

“Grant 55”作为答案。

Answer 1

Select E.LName, SUM(Hours) as HOURS    
From WORKS_ON W    
   JOin EMPLOYEE E on E.SSN=W.ESSN    
group by E.LName
ORDER BY HOURS desc
limit 1