For cats age means seniority, we would like to rank the cats by age (oldest first).
However we would like their ranking to be sequentially increasing.
Return: ranking, name, age
Order by: ranking, name Show Table Schema
Correct output but can you use 'dense_rank'?
dense_rank() differs from rank() as it increases sequentially.
Consider a race where 2 people finished first. Dense_rank assigns the next person 2nd. Rank assigns them 3rd. next question
select dense_rank() over (order by age DESC) as r, name,age from cats order by r, name