Using the function LISTAGG to create a list inside a table.
Below is the sql statement used.
select emp.last_name
, '<ul>'
||LISTAGG('<li>'||job.job_title||'</li>',' ')
within group (order by joh.start_date desc)
||'</ul>' job_history
, emp.hire_date
from oehr_employees emp
join oehr_job_history joh
on joh.employee_id = emp.employee_id
join oehr_jobs job
on joh.job_id = job.job_id
group by emp.last_name
, emp.hire_date