SELECT LYKS00,YPMC00,YPZSL0,YPGG00 FROM (

SELECT X.LYKS00,Y.YPMC00,Y.YPGG00,

ROUND(SUM(X.YPZSL0*X.ZHL000)/Y.K2J000,3)||'('||Trim(Y.KCDW00)||')' YPZSL0 

FROM VW_YF_BRYY X,BM_YD0000 Y,YF_YPKCXX D 

WHERE X.YFBMBH+0=518 AND X.YPNM00=Y.YPNM00   

AND EXISTS (SELECT 1 FROM BM_YD0000 D WHERE D.DXSYBZ='1' 

                AND X.YPNM00=D.YPNM00) 

AND FYRQ00>='20180412' AND FYRQ00<='20180412' 

AND FYRQ00||FYSJ00>='2018041200:00:00' AND FYRQ00||FYSJ00<='2018041223:59:59' 

GROUP BY X.LYKS00,Y.YPMC00,Y.KCDW00,Y.K2J000,Y.YPGG00 

 UNION ALL 

SELECT ' ºÏ   ¼Æ' LYKS00,Y.YPMC00,Y.YPGG00, 

ROUND(SUM(X.YPZSL0*X.ZHL000)/Y.K2J000,3)||'('||Trim(Y.KCDW00)||')' YPZSL0 

FROM VW_YF_BRYY X,BM_YD0000 Y,YF_YPKCXX D 

WHERE X.YFBMBH+0=518 AND X.YPNM00=Y.YPNM00 

AND EXISTS (SELECT 1 FROM BM_YD0000 D WHERE D.DXSYBZ='1' 

                AND X.YPNM00=D.YPNM00) 

AND FYRQ00>='20180412' AND FYRQ00<='20180412' 

AND FYRQ00||FYSJ00>='2018041200:00:00' AND FYRQ00||FYSJ00<='2018041223:59:59' 

GROUP BY Y.YPMC00,Y.KCDW00,Y.K2J000,Y.YPGG00 

)ORDER BY LYKS00,YPMC00