[HackerRank] [SQL] Top Earners

문제 설명

문제 풀이

SELECT salary * months AS earnings
        , count(*)
FROM employee 
GROUP BY earnings 
ORDER BY earnings desc
LIMIT 1

실행 결과