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

SELECT (salary*months)as earnings,COUNT(*) FROM employee WHERE employee_id IN ( SELECT employee_id FROM employee WHERE months * salary in (SELECT MAX(months * salary) FROM employee ) ) group by salary*months;

SELECT (MONTHS*SALARY),COUNT((MONTHS*SALARY)) FROM EMPLOYEE GROUP BY (MONTHS*SALARY) ORDER BY (MONTHS*SALARY) DESC LIMIT 1 OFFSET 0;

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

select TOP 1
    MAX(total) as total,
    COUNT(*)
    from (
        select employee_id, name, salary * months AS total, months from Employee
    ) AS tabela
    GROUP BY total
    ORDER BY total desc