0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited nov 30

created nov 30 anonymous