ыф

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

select distinct count(*) over (partition by case when count(Posts.id) < 10 then 0
                         when count(Posts.id) >= 10 and count(Posts.id) <= 20 then 1
                         when count(Posts.id) > 20 then 2 end)
as Count from Posts
left join Users
on Users.id = Posts.OwnerUserId
group by Users.id

Enter Parameters

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