大神指点一下这种语句应该怎么优化
SELECT (SELECT listagg(to_char(RENWU), '<br>') WITHIN GROUP(order by ROWNUM)
FROM (SELECT (ROWNUM || '、' || RENWU) RENWU
FROM BO_EU_JSGC_XMZB_XZJH BEJXX
WHERE BEJX.BINDID = BEJXX.BINDID)) NEXT_WEEK,
(SELECT listagg(to_char(RENWU), '<br>') WITHIN GROUP(order by ROWNUM)
FROM (SELECT (ROWNUM || '、' || RENWU) RENWU
FROM BO_EU_JSGC_XMZB_WCQK BEJXX
WHERE BEJX.BINDID = BEJXX.BINDID)) LAST_WEEK,
(SELECT listagg(to_char(WANCHENGQINGKUANG), '<br>') WITHIN GROUP(order by ROWNUM)
FROM (SELECT (ROWNUM || '、' || WANCHENGQINGKUANG) WANCHENGQINGKUANG
FROM BO_EU_JSGC_XMZB_WCQK BEJXX
WHERE BEJX.BINDID = BEJXX.BINDID)) LAST_WEEK_QK,
(SELECT listagg(to_char(PCQK), '<br>') WITHIN GROUP(order by ROWNUM)
FROM (SELECT (ROWNUM || '、' || PCQK) PCQK
FROM (SELECT (JJFA.WENTI || ',' || JJFA.ZONGTIMUBIAO) PCQK
FROM BO_EU_JSGC_XMZB_JJFA JJFA
WHERE BEJX.BINDID = JJFA.BINDID
union all
SELECT (BGPC.MINGCHENG || ',' || BGPC.MIAOSHU) PCQK
FROM BO_EU_JSGC_XMZB_BGPC BGPC
WHERE BEJX.BINDID = BGPC.BINDID))) PCQK_YY
FROM BO_EU_JSGC_XMZB BEJX;