SELECT job_title, LISTAGG( first_name, ',' ) WITHIN GROUP( ORDER BY first_name ) AS employees FROM employees GROUP BY job_title ORDER BY job_title;