select sum (case when post < 10 then 1 else 0 end), sum (...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

select
sum (case when post < 10 then 1 else 0 end), 
sum (case when post >=10 and post <=20 then 1 else 0 end),
sum (case when post <20 then 1 else 0 end)
from (select OwnerUserId, count (id) as post from posts 
 where PostTypeId=1
 group by OwnerUserId) as nou

Enter Parameters

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