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.
SELECT (salary*months)as earnings,COUNT(*)
FROM employee WHERE employee_id IN (
SELECT employee_id FROM employee
WHERE months * salary in (SELECT MAX(months * salary) FROM employee )
) group by salary*months;
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 →
SELECT (salary*months)as earnings,COUNT(*) FROM employee WHERE employee_id IN ( SELECT employee_id FROM employee WHERE months * salary in (SELECT MAX(months * salary) FROM employee ) ) group by salary*months;