MySQL solution-

select (salary * months)as earnings ,count(*) from employee group by 1 order by earnings desc limit 1;

Hello, There..

This is my first post on discussions.. Here is a solution for ORACLE:

SELECT * FROM (SELECT MAX(MONTHS*SALARY), COUNT(EMPLOYEE_ID) FROM EMPLOYEE GROUP BY MONTHS*SALARY ORDER BY MONTHS*SALARY DESC) WHERE ROWNUM = 1;

MySQL solution

From my HackerRank solutions.

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

Let me know if you have any questions.

Here is Oracle solution from my HackerrankPractice repository:

SELECT *
FROM (
    SELECT Months * Salary, COUNT(*)
    FROM Employee
    GROUP BY (Months * Salary)
    ORDER BY Months * Salary DESC
    )
WHERE ROWNUM = 1;

Feel free to ask if you have any questions :)

Sql server:

select top 1 months * salary as earnings, count (*) from employee group by months * salary order by 1 desc