Gini coefficient for number of posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

select b.users_quantile, b.posts_quantile/(max(b.posts_quantile) over (order by b.users_quantile))
from
(
Select count(n_posts) OVER(ORDER BY n_posts+0.000000001*OwnerUserId Desc) users_quantile, 
sum(n_posts) OVER(ORDER BY n_posts+0.000000001*OwnerUserId Desc) posts_quantile
  from 
  (     select count(id) n_posts, OwnerUserId
        from Posts
        where PostTypeId = 2 and
              datepart(year, CreationDate)=2019
        group by OwnerUserId
  ) a 
) as b

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results