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 total_Earn AS (
SELECT
employee_id,
salary * months AS totalEarning
FROM Employee
)
SELECT concat(MAX(totalEarning),' ',COUNT(employee_id))
FROM total_Earn
WHERE totalEarning = (SELECT MAX(totalEarning) FROM total_Earn);
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 total_Earn AS ( SELECT employee_id, salary * months AS totalEarning FROM Employee ) SELECT concat(MAX(totalEarning),' ',COUNT(employee_id)) FROM total_Earn WHERE totalEarning = (SELECT MAX(totalEarning) FROM total_Earn);