SELECT MAX(salary * months),
COUNT(name) FROM Employee WHERE salary * months = MAX(salary * months)
FROM Employee;
이렇게 썼더니 오답... subquery를 썼다고 생각했지만, 그것은 나의 착각... 서칭을 해보자!
SELECT salary * months as earnings, COUNT(*)
FROM Employee
WHERE salary * months = (SELECT MAX(salary * months) FROM Employee)
GROUP BY earnings
GROUP BY, ORDER BY, LIMIT을 사용한 코드
SELECT salary * months AS earnings, COUNT(*)
FROM Employee
GROUP BY earnings
ORDER BY earnings DESC
LIMIT 1;