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.
MySQL (I think I overthought it lol): WITH a AS (
SELECT employee_id, salary * months AS tot_earn
FROM EMPLOYEE
),
b AS (
SELECT employee_id, MAX(tot_earn) AS max_earn
FROM a
GROUP BY employee_id
)
SELECT b.max_earn, COUNT(*)
FROM b
GROUP BY b.max_earn
ORDER BY b.max_earn DESC
LIMIT 1;
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 →
MySQL (I think I overthought it lol): WITH a AS ( SELECT employee_id, salary * months AS tot_earn FROM EMPLOYEE ), b AS ( SELECT employee_id, MAX(tot_earn) AS max_earn FROM a GROUP BY employee_id ) SELECT b.max_earn, COUNT(*) FROM b GROUP BY b.max_earn ORDER BY b.max_earn DESC LIMIT 1;