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

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 'lol' end),
count(case when t.own > 10 then 'hoh' end),
count(case when t.own between 10 and 20 then 'loll' 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