Dense Rank Employees by Salary

Problem

Rank everyone by salary, but handle ties fairly — employees with the same pay share a rank, and the sequence never skips a number. Using the employees table, assign each employee a dense rank from highest to lowest salary.

Return name, salary, and salary_rank, ordered by rank then name.

Schema

employees

Sample Data

Expected Output