ims_zhyshop_sun_suppliergoods表（商品）中price为销售价，cost_price为成本价，找到cost_price与price的差<3%的商品列表,写出sql语句

SELECT id,price,cost_price,
round((ABS(price - cost_price) / cost_price) * 100,1)  as ratio
FROM ims_zhyshop_sun_suppliergoods
WHERE  id < 10 and ABS(price - cost_price) / cost_price < 0.03;

ims_zhyshop_sun_suppliergoodsattrsetting（商品规格）表中price为销售价，supply_price为供应价，

找到cost_price与supply_price的差<3%的商品列表,写出sql语句

SELECT id,price,supply_price,
round((ABS(price - supply_price) / supply_price) * 100,1)  as ratio
FROM ims_zhyshop_sun_suppliergoodsattrsetting
WHERE  id < 10 and ABS(price - supply_price) / supply_price < 0.03;

改成销售价=成本价 * 115%(加15%)

UPDATE ims_zhyshop_sun_suppliergoods
SET price = cost_price * 1.15
WHERE id < 10 and ABS(price - cost_price) / cost_price < 0.03;

UPDATE ims_zhyshop_sun_suppliergoodsattrsetting
SET price = supply_price * 1.15
WHERE id < 10 and ABS(price - supply_price) / supply_price < 0.03;

找到销售价与供应价的差<3%的商品列表改成销售价=供应价 * 115%(加15%)