Query to Count number of records using Group By in SQL Server

Hi ps222,

Please refer below sample query.

SQL

DECLARE @TestDemo AS TABLE([type] VARCHAR(20), [date] DateTIME)
INSERT INTO @TestDemo VALUES('Security','2019-02-26')
INSERT INTO @TestDemo VALUES('Booking','2019-03-02')
INSERT INTO @TestDemo VALUES('Booking','2019-02-26')
INSERT INTO @TestDemo VALUES('Security','2019-02-28')
INSERT INTO @TestDemo VALUES('Cleanliness','2019-02-26')

SELECT [type] Type, COUNT([type]) [Count] FROM @TestDemo
WHERE [date] <= GETDATE()
GROUP BY [type]

Output

working for me

SELECT count(*) as countdata,year(created_date) as Year FROM tablename GROUP BY categioriestype;