Re: SQL help please

bhargav.desai_at_gmail.com wrote:

> 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

This is school work. Post your best attempt and enough of the table structure and data so we can see what you are working with.

You will get hints ... not answers.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)