update SKU
set
STD_COST_PRICE = GOODS.STD_COST_PRICE
, UPDATE_USER_NAME = 'MODIFY'
, USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
from 
(select GOODS_CODE, round(AVG(STD_COST_PRICE)) avg_price from SKU group by GOODS_CODE)avg_p
join GOODS on avg_p.GOODS_CODE = GOODS.GOODS_CODE
where 
SKU.GOODS_CODE = avg_p.GOODS_CODE
and SKU.STD_COST_PRICE < avg_p.avg_price
and SKU.GOODS_CODE = GOODS.GOODS_CODE;