title: Summarize Data with SQL statement
body: <p>I have CMS table that contain CMS_STARTTIME and CMS_STOPTIME (attachment). <br/>
  <a href="http://img339.imageshack.us/img339/755/exdatabase.jpg" rel="nofollow noreferrer">alt text http://img339.imageshack.us/img339/755/exdatabase.jpg</a></p>
  
  <p>I want to create report to summarize exist data by using Date, Time and Year as Parameter (attachment). <br/>
  <a href="http://img444.imageshack.us/img444/3508/reportdailyen.jpg" rel="nofollow noreferrer">alt text http://img444.imageshack.us/img444/3508/reportdailyen.jpg</a></p>
  
  <p>I don't know how to create sql statement to meet this requirement. I'm using MySQL and MS-SQL.
  Does one can help? <br/>
  Thank you very much.</p>