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
Correct output but can you use 'array_agg'?
array_agg allows us to group our data together. next question
select color, array_agg(name) as names from cats group by color order by color desc