We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
WITH EARNING AS
(SELECT *, (MONTHS*SALARY) AS 'TOTAL_EARNING' FROM EMPLOYEE)
SELECT TOP 1 TOTAL_EARNING, COUNT(*) FROM EARNING
GROUP BY TOTAL_EARNING
ORDER BY 1 DESC
Cookie support is required to access HackerRank
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 →
WITH EARNING AS (SELECT *, (MONTHS*SALARY) AS 'TOTAL_EARNING' FROM EMPLOYEE) SELECT TOP 1 TOTAL_EARNING, COUNT(*) FROM EARNING GROUP BY TOTAL_EARNING ORDER BY 1 DESC