计算一种商品
平均价
select sum(goods_number*goods_price)/sum(goods_number)
总价
select (sum(goods_number*goods_price)/sum(goods_number))*sum(goods_number)
计算一种商品
平均价
select sum(goods_number*goods_price)/sum(goods_number)
总价
select (sum(goods_number*goods_price)/sum(goods_number))*sum(goods_number)
转载于:https://my.oschina.net/xuyaoxiang/blog/748457