79163283

Date: 2024-11-06 15:44:48
Score: 1
Natty:
Report link

Your initial approach is almost there, it needs a key added in the object to yield the desired result:

SELECT species, array::group({id: id, age: age}) AS members FROM animal GROUP BY species;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: TheUnknown