SQL Query - Hourly Count

[karan_jhr]

Hi

I am not a DBA so please excuse me if this question is very basic

 

I want a report to know hourly count SUM number students who applied for admission between two dates.

 

I have a column called [TIME_SUBMITTED] in the table [ABC].[dbo].[TBL_ADMISSION]

 

What would be the query for this purpose?

 

thanks

Edited July 10, 2018 by karan_jhr

[karan_jhr]

solved

thanks