Select daily records

Hi, anyone know how to select data daily from 9am-3pm?
I have a program to auto run hourly, but I only want to show the daily data from 9am-3pm. and also total count base on hour.
eg:
9-10am, total is 10
10-11am total is xx
and so on..

Please provide:

  • database engine and version (ex. MSSQL 2008 R2)
  • table definition in the form of create statement
  • relevant sample data in the form of insert statement
  • expected output from the sample data you provide