Hi everyone -
I'm looking for sql to report the average sale per the day of the week. So the total Monday's average sales per hour, the total Tuesday's sales per hour for all the days of the week. Average sale with a rollup on day with sales per hour. At first I'd like to pull data from 1-1-09 through 6-24-09.
Your help would be appreciated.
Mon Tues Wed Thurs Fri Sat Sun
8am 9am 10am 11am 12am 1pm 2pm 3pm 4pm 5pm 6pm 7pm 8pm 9pm