oracle多个结果集拼接字符串

lwqpcf90t4

要求根据查询条件返回每个用户对于的欠费量、欠费金额、欠费次数、欠费期间（欠费期间是多个以,分割）
select     
m.yqzh,max(m.hz_mc),sum(m.sl),sum(m.yje),sum(m.num),max(m.dzms),
listagg(m.cbqijian , ',') within
GROUP(
order by m.yqzh) as qfqijian
from  
( select max(ys.fyjl_yqzh) as yqzh,
max(ys.fyjl_hz_mc) as hz_mc,
sum(ys.fyjl_sl) as sl,
sum(ys.fyjl_yje) as yje,
max(ys.fyjl_lxdh) as lxdh,
count(ys.fyjl_bi_id) as num,
max(ys.fyjl_yqdz_ms) as dzms,
max(substring(ys.fyjl_cbqijian,1,6)) as cbqijian
from feiyong_jilu_ys ys
where ys.fyjl_zt = '4'
and ys.fyjl_fylx_id = '31'
and ys.fyjl_fyxm_id = '3101'
and ys.fyjl_yqzh='D6000107'
group by ys.fyjl_bi_id
) m
group by m.yqzh

查询结果：