select case when score > 10 then 'Big score' else 'Little...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results