[해커랭크/SQL] 29. Top Earners

👉https://www.hackerrank.com/challenges/earnings-of-employees/problem?isFullScreen=true

Top Earners | HackerRank

---

 

🤔 문제 분석

1) Write a query to find the maximum total earnings for all employees

2) as well as the total number of employees who have maximum total earnings.

 

💡 풀이

SELECT months * salary, count(*)
FROM Employee
WHERE months * salary = (SELECT MAX(months * salary) AS max
                         FROM Employee)
GROUP BY months * salary