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.

MS SQL Solution

select max(months*salary),count(months*salary) from employee where employee_id in( select employee_id from employee where months*salary in (select max(months*salary) from employee));

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 :)