Rank Employees

Write a query that ranks employees by salary within each department using both RANK() and DENSE_RANK(). Return columns department, name, salary, salary_rank, and salary_dense_rank, ordered by department then by salary descending.