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