[HackerRank] Top Earners

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT MAX(salary * months) AS earnings
     , COUNT(*)
FROM Employee
GROUP BY salary*months
ORDER BY earnings DESC
LIMIT 1