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 CTE (employee_id,Earning)
As (SELECT employee_id, Salary * Months FROM Employee
)
SELECT CAST(Earning as Varchar(100)) + ' ' + CAST(Count(*) as Varchar(10))
FROM CTE WHERE Earning in (SELECT Max(Earning) FROM CTE)
GROUP BY Earning;
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 CTE (employee_id,Earning) As (SELECT employee_id, Salary * Months FROM Employee ) SELECT CAST(Earning as Varchar(100)) + ' ' + CAST(Count(*) as Varchar(10)) FROM CTE WHERE Earning in (SELECT Max(Earning) FROM CTE) GROUP BY Earning;