select count(case when cn<10 then 1 end), count(case when...

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 count(case when cn<10 then 1 end), count(case when (cn>=10 and cn<=20) then 1 end), count(case when cn>20 then 1 end)
from (
select owneruserid, count(*) cn
from posts
where posttypeid = (
select id
from posttypes
where name = '%Question%'
)
group by owneruserid
) as a

Enter Parameters

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