select count(case when t.own < 10 then '' end), count(cas...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature Meta

Q&A about the site for scholars and enthusiasts of literature

select count(case when t.own < 10 then '' end),
count(case when t.own > 20 then '' end),
count(case when t.own between 10 and 20 then '' end)
from (select count(id) as own from Posts group by OwnerUserId) as t

Enter Parameters

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