First of each Group


Cats are vain. Each cat would like to pretend it has the lowest weight for its color.

Print cat name, color and the minimum weight of cats with that color.

Return: name, color, lowest_weight_by_color
Order by: color, name

Show Table Schema

Click me!

Desired output:

name color weight_by_color
Ashes Black 4.2
Charlie Black 4.2
Molly Black 4.2
Oscar Black 4.2
Smudge Black 4.2
Alfie Brown 5.5
Misty Brown 5.5
Smokey Brown 5.5
Felix Tortoiseshell 3.8
Millie Tortoiseshell 3.8
Puss Tortoiseshell 3.8
Tigger Tortoiseshell 3.8
view answer

Your output: