• 計(jì)算各個(gè)用戶(hù)的消費(fèi)金額綜合
• 對(duì)用戶(hù)消費(fèi)金額進(jìn)行累加，并計(jì)算累計(jì)占比，就是貢獻(xiàn)度

select 
t.*
from
    (select 
    user_id 
    ,round(amount,2) amount
    ,round(sum(amount)over(order by amount desc) ,2) cum_amount
    ,round(sum(amount)over(order by amount desc)/(select sum(pur_amount) from cd_now),4) as cum_rate
    from 
        (select 
        user_id 
        ,sum(pur_amount) amount
        from 
        cd_now 
        where pur_amount >0
        group by 
        user_id ) user_table
    ) t
where t.cum_rate<0.8