WITH SKUAVG AS (
SELECT
	GOODS_CODE AS GOODS_CODE
	,ROUND(AVG(STD_COST_PRICE)) AS STD_COST_PRICE
FROM SKU
GROUP BY
	GOODS_CODE 
)
UPDATE SKU SET
    STD_COST_PRICE = (SELECT STD_COST_PRICE FROM GOODS WHERE GOODS.GOODS_CODE = SKU.GOODS_CODE)
    ,UPDATE_USER_NAME = 'MODIFY'
    ,USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
WHERE EXISTS (
    SELECT
        *
    FROM SKUAVG
    WHERE SKUAVG.GOODS_CODE = SKU.GOODS_CODE
    AND SKUAVG.STD_COST_PRICE > SKU.STD_COST_PRICE
)
;
SELECT
    *
FROM SKU
WHERE UPDATE_USER_NAME = 'MODIFY'
;