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

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

Enter Parameters

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