select 

t.comp_code,

t.khfl1_txt, 

t.jsl - t.jhl as kcl 

from(

SELECT  

comp_code,

khfl1_txt,

sum(msdjsqty)/count(doc_num) AS jsl,

sum(nvl(act_dl_qty,0)) AS jhl 

from app_yp.yc_kc_orc where jsdat <= '2022-12-20' 

group by comp_code,khfl1_txt

) t

内层sql用聚合函数怎么不分组呢

select t.comp_code,t.khfl1_txt, sum(t.jsl - t.jhl) as kcl  

from(

SELECT  comp_code,khfl1_txt,sum(msdjsqty)/count(doc_num) AS jsl,sum(nvl(act_dl_qty,0)) AS jhl from app_yp.yc_kc_orc where jsdat <= '2022-12-20' 

) t

GROUP BY    t.comp_code,t.khfl1_txt

select t.comp_code,t.khfl1_txt, t.jsl - t.jhl as kcl 

from(

SELECT  comp_code,khfl1_txt,sum(msdjsqty)/count(doc_num) AS jsl,sum(nvl(act_dl_qty,0)) AS jhl from app_yp.yc_kc_orc where jsdat <= '2022-12-20' 

GROUP BY    comp_code,khfl1_txt

) t

当有聚合函数出现时 后面需要跟group by，你的group by应该放在括号前