SQL Server 2012 :: Creating Buckets For Sales Data

Recently I've been stumbling with a way to properly produce a result that provides me a count of sales orders that fall in a range of sales order totals.

I want to take the Sales Order Total and then count how many times it falls into a specific bucket.

I've included the script where I've left with sample data so you can run in into a tempdb.

I hope to have the end result look like the below summary if you use my sample data.

Count Less Than 5K: 5
Count Greater Than 5K Less Than 10K: 0
Count Greater Than 10K Less Than 25K: 3
Count Greater Than 25K: 2

Here is the script to set up the tempdb

use tempdb
go
/*
drop table #salesinvoice;
drop table #salesinvoicedetail;

[Code] ....

Below is my query, I change it to perform a count on the summarized totals.

select
si.OrderID as OrderNum
,sum(case when sid.LineAmount < 5000 then 1 else 0 end) as LT5K
,sum(case when sid.LineAmount >=5000 and sid.LineAmount < 10000 then 1 else 0 end) as GT5kLT10k
,sum(case when sid.LineAmount >=10000 and sid.LineAmount < 25000 then 1 else 0 end) as GT10kLT25k

[Code] ....

Here are the order totals.

SI201 = 41450
SI202 = 11600
SI203 = 1210
SI204 = 16001
SI205 = 2750
SI206 = 12500
SI207 = 25450
SI208 = 4500
SI209 = 3850
SI210 = 2575

And the desired result would tell me the below summary. The final query can be column based. I just write this in rows for clarity.

Count Less Than 5K: 5
Count Greater Than 5K Less Than 10K: 0
Count Greater Than 10K Less Than 25K: 3
Count Greater Than 25K: 2
******/