prev question

next question

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

Cats:

name	varchar
breed	varchar
weight	float
color	varchar
age	int

select * from cats

Click me!

Run Query Show Hint

This query requires:

Correct output but can you use 'dense_rank'?

Desired output:

r	name	age
1	Alfie	5
1	Ashes	5
1	Millie	5
2	Charlie	4
2	Smokey	4
2	Smudge	4
3	Felix	2
3	Misty	2
3	Puss	2
3	Tigger	2
4	Molly	1
4	Oscar	1

view answer

select dense_rank() over (order by age DESC) as r, name,age from cats order by r, name

Your output: