update SKU as srcsku SET STD_COST_PRICE = (select STD_COST_PRICE from GOODS where GOODS.GOODS_CODE = srcsku.GOODS_CODE)
where (select AVG(STD_COST_PRICE) from SKU sku where srcsku.GOODS_CODE = sku.GOODS_CODE) > srcsku.STD_COST_PRICE;