0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited nov 30

created nov 18 19 anonymous