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 large_10_and_less_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