Dense Rank Employees by Salary

Write a SQL query that ranks every employee by salary **within their
department using dense ranking** (no gaps when salaries are tied).
Order the output by department, then rank, then name.

Table: `employees`

Alice and Bob are tied → both rank 1; Carol is rank 2 (dense, no gap).

Expected output (columns: name, dept, salary, rank)

Alice|Engineering|90000|1
Bob|Engineering|90000|1
Carol|Engineering|75000|2
Dave|Marketing|80000|1
Eve|Marketing|80000|1
Frank|Marketing|60000|2

DENSE_RANK vs RANK — RANK skips numbers after a tie (1,1,3);

DENSE_RANK never skips (1,1,2).