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


select b.users_quantile, b.posts_quantile/(select max(b.posts_quantile) from b) from b

fork query

edited nov 8 19

created nov 8 19 anonymous