10 lines
222 B
SQL
10 lines
222 B
SQL
-- Author: Rodney Shaghoulian
|
|
-- Github: github.com/RodneyShag
|
|
-- HackerRank: hackerrank.com/RodneyShag
|
|
|
|
SELECT salary * months AS earnings, COUNT(*)
|
|
FROM Employee
|
|
GROUP BY earnings
|
|
ORDER BY earnings DESC
|
|
LIMIT 1;
|