Totals for all sales per hour for a specific date range
(This query will help if you need to find a pattern of how busy the box is by hours and days of the week so you can manage box office personnel schedules.)
select hour(today_time) as Hour, sum(total_tix) as Tix, sum(total_sale) as Sales
from mainsale
where today_date >= “20xx-<month>-<date>”
and today_date <= “20xx-<month>-<date>”
group by hour(today_time)
