I have a table of transactions data for a store. It has a field td_datetimstamp which stores the time at which the transaction takes place. And td_record_type stores the count of the customer. Now, I want to generate a report which has the customer count on an hourly basis. How do i write a query to return the count on an hourly basis when a date is passed as a parameter?