全部评论
select user_id, date, user_daily_gmv/total_daily_gmv as gmv_perc from ( select t1.user_id, t1.date, sum(t2.price*t1.count)over(partition by t1.user_id,t1.date) as user_daily_gmv, sum(t2.price*t1.count)over(partition by t1.date) as total_daily_gmv, from user_iap t1 left join product_daily_price t2 on (t1.sku=t2.sku and t1.date = t2.date) )t0 where user_daily_gmv/total_daily_gmv>0.1
送花
回复 分享
相关推荐
06-14 22:51
新乡工程学院 电子信息类 点赞 评论 收藏
分享