Newbie : Group by price SQL

From: Rich <richmarin_at_earthlink.net>
Date: 29 Jul 2003 15:16:38 -0700
Message-ID: <46e4ef1a.0307291416.2fff846a@posting.google.com>

I need to create a daily report that shows management sales group by price. I wanted to know if it is possible to use a single SQL statement in order to do this. The report will look something like this :

                 Column A       Column B            Column C   Total

of A, B, C

               Price < $10 Price > $11 to < $20 Price > $21

Customer A $1,000.00 $500.00 $20.00 $1,520.00 Received on Tue Jul 29 2003 - 17:16:38 CDT