Aggregating data


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 Ashes,Molly,Smudge,Oscar,Charlie
view answer

Your output: