You are viewing a single comment's thread. Return to all comments →
SELECT (SALARY MONTHS) AS EARNINGS, COUNT() FROM EMPLOYEE GROUP BY EARNINGS ORDER BY EARNINGS DESC LIMIT 1;
This reduces a lot of confusion, makes us understand what happens.
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 →
SELECT (SALARY MONTHS) AS EARNINGS, COUNT() FROM EMPLOYEE GROUP BY EARNINGS ORDER BY EARNINGS DESC LIMIT 1;
This reduces a lot of confusion, makes us understand what happens.