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