求助1:想查wanchengdan,liushui,butie的环比.
selectb.city,b.busi_name,
count(if(a.order_status=9,a.order_id,null))as'wanchengdan',
sum(if(a.order_status=9,real_total_price,0))/1000as'liushui',
sum(if(order_status=9,ifnull(discount_baidufee_price,0),0))/1000as'butie',
sum(if(order_status=9,ifnull(shop_butie,0),0))/1000as'shanghubutie',
sum(if(a.order_status=9,real_total_price,0))/sum(if(order_status=9,ifnull(discount_baidufee_price,0)+ifnull(discount_fanquan,0),0))as'roi'
fromfact_ordera,dim_businessb
wherea.shop_id=b.shop_id
anda.break_type=0
anda.order_day_keybetween20161104and20161110
andb.is_test=0
andb.ka_extend_lable_id=10
groupby1,2
求助2.aoi是商圈,busi_name是店名,想查所有商圈订单量排名前十的店。
selectb.city,b.aoi,b.busi_name,
count(if(a.order_status=9,a.order_id,null))as'wanchengdan'
fromfact_ordera,dim_businessb
wherea.shop_id=b.shop_id
anda.break_type=0
anda.order_day_keybetween20161111and20161117
andb.is_test=0
groupbyb.city,b.aoi,b.busi_name
跪谢各位大神...
分 -->
|