You are viewing a single comment's thread. Return to all comments →
Can you please explain why you need the order by earnings in addition to the group by 1? :)
my solution was the same but without the order by earnings
SELECT (MONTHS*SALARY) AS EARNINGS, COUNT(*) FROM EMPLOYEE GROUP BY 1 DESC LIMIT 1;
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 →
Can you please explain why you need the order by earnings in addition to the group by 1? :)
my solution was the same but without the order by earnings