Gini coefficient for number of posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

select log(users_quantile,10), posts_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, GETDATE())=2019
        group by OwnerUserId
  ) a 
) b

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results