select	category
	,count(*) [count]
from	(
	select case
		when freight < 10 then 'CAT1'
		when freight >10 and freight < 20 then 'CAT2'
		when freight >20 and freight < 30 then 'CAT3'
		when freight >30 and freight < 40 then 'CAT4'
		when freight >40 then 'CAT5'
		end as category
	from orders
	) a
group by category
order by category

output:
category count       
-------- ----------- 
CAT1     176
CAT2     91
CAT3     80
CAT4     64
CAT5     419