GROUP_CONCAT

1
SELECT
2
  category,
3
  GROUP_CONCAT(product_name, ', ') as products
4
FROM products
5
GROUP BY category;

1
SELECT
2
  department,
3
  GROUP_CONCAT(employee_name, ' | ') as team_members
4
FROM employees
5
GROUP BY department;

1
SELECT
2
  article_id,
3
  article_title,
4
  GROUP_CONCAT(tag_name) as tags
5
FROM articles
6
JOIN article_tags USING (article_id)
7
JOIN tags USING (tag_id)
8
GROUP BY article_id, article_title;