You are viewing a single comment's thread. Return to all comments →
select employee_id, months * salary as total into #total_earnings from Employee
select total, count(distinct employee_id) from #total_earnings where total = (select max(total) from #total_earnings) group by total
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 employee_id, months * salary as total into #total_earnings from Employee
select total, count(distinct employee_id) from #total_earnings where total = (select max(total) from #total_earnings) group by total