Top Earners

  • + 0 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