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.GOODS_CODE, STD_COST_PRICE FROM GOODS WHERE GOODS_CODE IN (
    SELECT GOODS_CODE FROM SKU S2 JOIN 
    (SELECT GOODS_CODE, ROUND(AVG(STD_COST_PRICE)) AS STD_COST_PRICE FROM SKU GROUP BY GOODS_CODE) S3
    USING (GOODS_CODE) WHERE S2.STD_COST_PRICE < S3.STD_COST_PRICE
  )
) GOODS
WHERE SKU.GOODS_CODE = GOODS.GOODS_CODE;