How to write a case when statement when there are overlaps in T-SQL

user_5335473 0
Viewed 1020

I have a table like this

enter image description here

How can I group it to this

enter image description here

Small is the sum of the count when Count <25; Large is the sum of the count when Count>=25; Total is the sum of all counts.

tsql sql-server
3 Answers
Related