Top Earners

  • + 0 comments

    For MySQL

    SELECT salary*months AS total_earnings, COUNT(*) FROM employee
    GROUP BY 1
    ORDER BY 1 DESC LIMIT 1;