Top Earners

  • + 0 comments

    Frist tried to use MAX() function, sort + limit solutions appeared to be more handy... If someone know how to reduce into one MONTHS * SALARY variable, I would be grateful to learn

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