You are viewing a single comment's thread. Return to all comments →
SELECT Salary*Months, COUNT(*) FROM employee WHERE Salary*Months IN (SELECT MAX(Salary*Months) FROM employee) GROUP BY Salary*Months
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, COUNT(*) FROM employee WHERE Salary*Months IN (SELECT MAX(Salary*Months) FROM employee) GROUP BY Salary*Months