Return dept_id, first_name, salary and dept_rank — RANK by salary within each department (highest = 1). Skip employees with no department.
dept_id
first_name
salary
dept_rank
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.