.產(chǎn)品貢獻(xiàn)定量分析（帕累托分析）(累積銷售額占比=累積銷售額/總銷售額)
select *
from
(select
item_category,
sum(amount) as 銷售額,
sum(sum(amount)) over(order by sum(amount) desc) as 累積銷售額,
#當(dāng)over中指定了排序,但是沒有指定滑動(dòng)窗口范圍時(shí),默認(rèn)計(jì)算當(dāng)前分區(qū)內(nèi)第一行到當(dāng)前行(排序字段)取值范圍內(nèi)的記錄
sum(sum(amount)) over() as 總銷售額,
#當(dāng)over中沒有指定分區(qū)、排序和滑動(dòng)窗口范圍時(shí),表中所有記錄為一個(gè)區(qū),默認(rèn)計(jì)算當(dāng)前分區(qū)內(nèi)的所有記錄
sum(sum(amount)) over(order by sum(amount) desc)/sum(sum(amount)) over() as 累積銷售額占比
from userbehavior_new
where behavior_type='buy'
group by item_category) as t
where 累積銷售額占比<=0.8;