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