0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

select case when score > 10 then 'Big score' else 'Little score' end as ScoreType, count(1) as ct
from posts
group by case when score > 10 then 'Big score' else 'Little score' end

fork query

edited aug 18

created aug 18 anonymous