在MySQL中使用多个连接和group_concat()？

-- 创建测试用表
CREATE TABLE employees (
  id INT AUTO_INCREMENT PRIMARY KEY,
  first_name VARCHAR(50),
  last_name VARCHAR(50),
  position VARCHAR(100)
);

-- 添加测试数据
INSERT INTO employees (first_name, last_name, position)
VALUES
  ('John', 'Doe', 'Software Engineer'),
  ('Jane', 'Doe', 'Software Engineer'),
  ('Bob', 'Smith', 'Sales Manager'),
  ('Alice', 'Brown', 'Marketing Specialist');

-- 使用多个连接和GROUP_CONCAT()查询员工姓名及职位
SELECT
  id,
  GROUP_CONCAT(first_name, ' ', last_name, ' ', position SEPARATOR '; ') AS employee_names_and_positions
FROM
  employees
GROUP BY
  id;

1; John Doe; Software Engineer
2; Jane Doe; Software Engineer
3; Bob Smith; Sales Manager
4; Alice Brown; Marketing Specialist