Further Orderring

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

Click me!

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

Your output: