How do you bucket data? 2

[pwills]

E.g.
CustID Orders
1 10
2 5
3 5

View to show

Bucket Count
0-9 2
10-19 1
20-29 0

 

[MeanGreen]

You could try this:

select case when Quantity < 10 then '0-9'
when Quantity between 10 and 19 then '10-20'
when Quantity >= 20 then '>= 20'
else null
end,count(*)
from

group by case when Quantity < 10 then '0-9'
when Quantity between 10 and 20 then '10-20'
when Quantity > 20 then '>20'
else null
end

Hope this helps.

 

[mwolf00]

Great Answer! You get another star (as if you needed more). -- What did you expect? This is FREE advice. LOL