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 Tigger,Puss,Felix,Millie
Brown Smokey,Misty,Alfie
Black Charlie,Molly,Smudge,Oscar,Ashes
view answer

Your output: