0

Please login or register to vote for this query.

(click on this box to dismiss)

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

with b as (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, datepart(month, CreationDate) monthli, OwnerUserId
        from Posts
        where PostTypeId = 2 and
              datepart(year, CreationDate)=2019 
        group by OwnerUserId, datepart(month, CreationDate)
  ) a 
)


select b.users_quantile, 1.000*b.posts_quantile/(select max(1.000*b.posts_quantile) from b) posts_percentage from b

fork query

edited nov 8 19

created nov 8 19 anonymous