JSON_ARRAYAGG

1
SELECT department,
2
       JSON_ARRAYAGG(employee_id) AS employee_ids
3
FROM employees
4
GROUP BY department;

1
SELECT JSON_ARRAYAGG(product_name) AS products
2
FROM products
3
WHERE category = 'Electronics';

1
SELECT JSON_ARRAYAGG(name) AS sorted_names
2
FROM (
3
  SELECT name FROM employees
4
  ORDER BY name
5
) AS sorted;