Top Earners
문제
코드
MySQL
SELECT salary * months AS earnings
, count(*)
FROM employee
GROUP BY earnings
ORDER BY earnings DESC
LIMIT 1
SELECT salary * months AS earnings
, count(*)
FROM employee
GROUP BY earnings
ORDER BY earnings DESC
LIMIT 1