每个渠道销售情况统计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 b
where a.my_share_id=b.my_share_id and a.member_id='JK_12345678'
group by share_channel;