Select sum(case when b.cnt < 10 then 1 else 0 end), sum(c...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

Select 
  sum(case when b.cnt < 10 then 1 else 0 end),
  sum(case when b.cnt between 10 and 20 then 1 else 0 end),
  sum(case when b.cnt > 20 then 1 else 0 end)
from ( Select Count(*) as cnt from Posts where PostTypeId= 1 Group by OwnerUserId ) as b

Enter Parameters

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