Maximum total compensation


You're given the following table showing information about employees at a company:

Table: emp_info

department emp_id salary_annual bonus
eng 1234 150000 20000
eng 1235 125000 15000
eng 1236 110000 17000
sales 4454 110000 25000
sales 4432 145000 7000
marketing 4430 130000 12000
marketing 1299 135000 18000

Using the table above, write a SQL query to return the emp_id of the employee with the highest total compensation. Make sure your query is able to handle potential ties (e.g. if there is a tie, should return all emp_ids that tie for the highest total compensation).

You can view/query the data in an interactive SQL fiddle here.


Access restricted

Subscribe to premium account to see the solution.

Get premium now