Top Earners

  • + 0 comments
    /*
    Enter your query here.
    MYSQL */
    
    SELECT MAX(SALARY*MONTHS) AS EARNINGS, COUNT(NAME) FROM EMPLOYEE
    GROUP BY (SALARY*MONTHS)
    ORDER BY (SALARY*MONTHS) DESC
    LIMIT 1;