You are viewing a single comment's thread. Return to all 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
Seems like cookies are disabled on this browser, please enable them to open this website
Top Earners
You are viewing a single comment's thread. Return to all comments →