select department_id, listagg(last_name, '; ') within group (order by employee_id) emp_list from hr.employees group by department_id;