Return dept_id, first_name and salary of the highest-paid person in each department (all of them if tied). Skip employees with no department.
dept_id
first_name
salary
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.