- URL : https://www.hackerrank.com/challenges/earnings-of-employees/problem
- We define an employee’s total earnings to be their monthly salary * months worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employee table. Write a query to find the maximum total earnings for all employees as well as the total number of employees who have maximum total earnings. Then print these values as 2 space-separated integers.
- MySQL Solution
1 2 3 4 select months * salary as earnings, count(*) from employee group by earnings order by earnings desc limit 1