数据分组求和

-- 分组在求和 count_tb 表的别名
select count(*) from (
SELECT
COUNT(de.CM_ID) as cm_id_count
FROM
do_deliveryorderline de
LEFT join
do_deliveryorderheader d on
de.doh_id= d.doh_id
LEFT join im_item i on
de.im_id=i.IM_ID
WHERE 
d.WH_CODE_ORIGIN ='EEUDCA'
and d.DS_CODE='R'
    group by i.IM_CODE) count_tb;


SELECT
i.IM_BARCODE as imBarcode,
sum(d.TOTAL_QUANTITY)  as receivedQuantity
FROM
do_deliveryorderline de
LEFT join do_deliveryorderheader d on de.doh_id= d.doh_id
LEFT join im_item i on de.im_id=i.IM_ID
WHERE
d.WH_CODE_ORIGIN = 'EEUDCA'
and d.DS_CODE='R'
group by i.IM_CODE
order by receivedQuantity desc