select(select count(id) from users) as result from ( sele...

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(select count(id) from users) as result
from (
select OwnerUserId, count(*) c
from posts
where PostTypeId in 
(select id from PostTypes where name = 'Question')
group by OwnerUserId
) as x
group by c
having (c<10 or c between 10 and 20 or c>20)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results