select count(case when <10 then 'a' end), count...


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for professional and amateur woodworkers

--select top 100 * from users
--select count(DisplayName) from users where DisplayName like '%John%' or DisplayName like '%Ivan%'

select count(case when <10 then 'a' end), count(case when >=10 and<=20 then 'b' end), count(case when>20 then 'c' end)  from (select count(posts.OwnerUserId) as post from users left join posts on users.Id = posts.OwnerUserId group by users.Id) as num

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results