update SKU set STD_COST_PRICE = gc.gstd, UPDATE_USER_NAME = 'MODIFY', USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
from (select GOODS_CODE, round(avg(STD_COST_PRICE), 1) as astd from SKU group by GOODS_CODE) as ac
join (select GOODS_CODE, STD_COST_PRICE as gstd from GOODS) as gc on ac.GOODS_CODE = gc.GOODS_CODE
where SKU.GOODS_CODE = ac.GOODS_CODE and SKU.STD_COST_PRICE < ac.astd and SKU.GOODS_CODE = gc.GOODS_CODE;