More Grouping

Question:

The cats want to show their weight by breed. The cats agree that they should show the second lightest cat's weight (so as not to make other cats feel bad)

Print a list of breeds, and the second lightest weight of that breed


Return: name, imagined_weight
Order by: breed

Show Table Schema

Click me!

Desired output:

breed imagined_weight
British Shorthair 4.8
Maine Coon 5.7
Persian 4.5
Siamese 5.5
view answer

Your output: