UPDATE SKU
 SET STD_COST_PRICE=SUB.STD_COST_PRICE,
     UPDATE_USER_NAME = 'MODIFY',
     USER_UPDATE_DATETIME ='2024-08-31 00:00:00'
     
 FROM
  (SELECT SK.GOODS_CODE,
          GD.STD_COST_PRICE,
          ROUND(AVG(SK.STD_COST_PRICE))AS SCP
          FROM SKU AS SK
          INNER JOIN GOODS AS GD
          ON GD.GOODS_CODE = SK.GOODS_CODE
          GROUP BY SK.GOODS_CODE
          ) AS SUB
          
WHERE SUB.GOODS_CODE = SKU.GOODS_CODE
      AND SKU.STD_COST_PRICE < SUB.SCP;
      
      SELECT * FROM SKU
      ORDER BY SKU_CODE ASC;