每个渠道销售情况统计sql
select a.member_id,a.share_channel,sum(a.share_PV),sum(a.share_point),count(b.my_share_id),sum(order_amount),sum(order_brokerage) from my_share a, my_share_order bwhere a.my_share_id=b.my_share_id
原创
2016-03-15 18:29:56 ·
2046 阅读 ·
0 评论