Need SQL

Question

  Hi,
         What I need is a SQL which will bring data something like below image, parameter to       SQL will be start date time and end date time.

      Output: count with time interval

 Problem is, I could not understand how should I make legends like below which takes 2 hours interval?