SELECT dept_no, GROUP_CONCAT(emp_no ORDER BY emp_no ASC separator ',') AS employees FROM dept_emp GROUP BY dept_no