Aggregating data

Question:

We would like to group our cats by color

Return 3 rows, each row containing a color and a list of cat names


Return: color, names Order by: color DESC

Show Table Schema

Click me!

Desired output:

color names
Tortoiseshell Felix,Tigger,Millie,Puss
Brown Alfie,Misty,Smokey
Black Molly,Ashes,Smudge,Oscar,Charlie
view answer

Your output: