SELECT help

I'm trying to figure out how to do a SELECT, but don't know how...

Ideally I'd like to get a table listing the total number of calls received from 8h-18h in 1 hr chunks

The following:
SELECT date, count(*) FROM calls
 WHERE date >= '01-APR-2003'
 GROUP BY date;
works good for displaying all the calls generated each day.

I can also add additional statements to nail down calls between 08:00 and 09:00 for example, but I guess I'd like to have one query that would generate something like:

DATE              DAY  8    9    10    ...
01-APR-2003    75    11    7    19    ...
02-APR-2003    66    3     5    3    ...

Where column DAY lists the total for each day, column 8 will list all the calls received between 08:00 and 08:59, column 9 will ist all the calls received between 09:00 and 9:59, etc

I've got troubles trying to generate multiple selects to do this.

Thanks!
Rob Received on Thu Apr 10 2003 - 16:04:39 CDT