Orderring

Question:

We would like to find the fattest cat. Order all our cats by weight.

The two heaviest cats should both be 1st. The next heaviest should be 3rd.


Return: ranking, weight, name
Order by: ranking, name

Show Table Schema

Click me!

Desired output:

ranking weight name
1 6.1 Oscar
1 6.1 Smokey
3 5.7 Misty
4 5.5 Alfie
5 5.4 Millie
6 5.1 Puss
7 5.0 Felix
8 4.9 Smudge
9 4.8 Charlie
10 4.5 Ashes
11 4.2 Molly
12 3.8 Tigger
view answer

Your output: