Top Earners

  • + 0 comments
    SELECT
    CONCAT(
       MAX(salary*months)
        ,' '
        ,COUNT(name)
          )
    FROM Employee
    WHERE salary*months =  (SELECT MAX(salary*months) FROM Employee);