Top Earners

  • + 0 comments
    WITH A AS
        (SELECT EMPLOYEE_ID ID,SUM(MONTHS * SALARY) TOTAL
         FROM EMPLOYEE
         GROUP BY EMPLOYEE_ID)
    
    SELECT TOTAL,COUNT(*)
    FROM A
    WHERE TOTAL = (SELECT MAX(TOTAL) FROM A)
    GROUP BY TOTAL