Syntax :
SELECT YEAR(DateColumn) AS [Year],MONTH(DateColumn) AS [Month],COUNT(*) from tablename Group By YEAR(DateColumn) MONTH(DateColumn)
Example :
DECLARE @temp TABLE (ID INT,Location varchar(50))
INSERT INTO @temp VALUES(1,'Gurukul''s Society')
SELECT * FROM @temp
SELECT YEAR(DateColumn) AS [Year],MONTH(DateColumn) AS [Month],COUNT(*) from tablename Group By YEAR(DateColumn) MONTH(DateColumn)
Example :
DECLARE @temp TABLE (ID INT,Location varchar(50))
INSERT INTO @temp VALUES(1,'Gurukul''s Society')
SELECT * FROM @temp