牛客96900986...：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