-- select T.*, GOODS.STD_COST_PRICE as a 
-- from (
-- select GOODS_CODE,avg(STD_COST_PRICE) as av from SKU
-- group by GOODS_CODE
-- ) as T 
-- join GOODS on GOODS.GOODS_CODE = T.GOODS_CODE
-- where a < T.av
-- ;

-- select SKU_CODE from SKU
-- join (
-- select GOODS_CODE,avg(STD_COST_PRICE) as av from SKU
-- group by GOODS_CODE
-- ) as T1 on SKU.GOODS_CODE = T1.GOODS_CODE
-- join GOODS on GOODS.GOODS_CODE = SKU.GOODS_CODE
-- where GOODS.STD_COST_PRICE < T1.av
-- ;


UPDATE SKU SET STD_COST_PRICE = GOODS.STD_COST_PRICE,UPDATE_USER_NAME='MODIFY',USER_UPDATE_DATETIME='2024-08-31 00:00:00' 
from GOODS
    join (
    select GOODS_CODE,avg(STD_COST_PRICE) as av from SKU
    group by GOODS_CODE
    ) as T1 on GOODS.GOODS_CODE = T1.GOODS_CODE
where GOODS.GOODS_CODE = SKU.GOODS_CODE and GOODS.STD_COST_PRICE < T1.av
;