find-latest-salaries.sql

# Time:  O(nlogn)
# Space: O(n)

SELECT 
    emp_id,
    firstname,
    lastname,
    MAX(salary) AS salary,
    department_id   
FROM Salary
GROUP BY emp_id
ORDER BY emp_id ASC;