SQL help please

Hello Gurus,

I am trying to do following. I have a table that contains field table1.Blanace (Numeric). On this field I want to write a SQL query that gives me count and sum on ranges.

For example,

Balance Range      Count     Sum
200-300             5       $1255.00
100-200             2       $179.25
less then 100     456       $4464.25

Thanks in Advance Received on Fri Jan 14 2005 - 12:30:17 CST