查询某时间段订单各金额总和

2019独角兽企业重金招聘Python工程师标准>>>

订单总金额

select sum((goods_amount - discount + tax + shipping_fee + insure_fee + pay_fee + pack_fee + card_fee)) AS total_fee from ecs_order_info where pay_status=2 and shipping_status in(1,2,4) and shipping_time>1469952000 and shipping_time<1472630400

红包

select sum(bonus) from ecs_order_info where pay_status=2 and shipping_status in(1,2,4) and shipping_time>1469952000 and shipping_time<1472630400

配送费

select sum(shipping_fee) from ecs_order_info where pay_status=2 and shipping_status in(1,2,4) and shipping_time>1469952000 and shipping_time<1472630400

余额

select sum(surplus) from ecs_order_info where pay_status=2 and shipping_status in(1,2,4) and shipping_time>1469952000 and shipping_time<1472630400

订单数

select count(order_id) from ecs_order_info where pay_status=2 and shipping_status in(1,2,4) and shipping_time>1469952000 and shipping_time<1472630400

转载于:https://my.oschina.net/xuyaoxiang/blog/754872