Hi ps222,
Please refer below sample query.
SQL
DECLARE @TestDemo AS TABLE(record VARCHAR(10), [month] DATETIME)
INSERT INTO @TestDemo VALUES(20,'01-02-2018')
INSERT INTO @TestDemo VALUES(20,'01-02-2019')
INSERT INTO @TestDemo VALUES(20,'01-02-2018')
INSERT INTO @TestDemo VALUES(50,'05-13-2018')
INSERT INTO @TestDemo VALUES(70,'06-05-2018')
INSERT INTO @TestDemo VALUES(50,'04-05-2019')
INSERT INTO @TestDemo VALUES(50,'04-05-2019')
INSERT INTO @TestDemo VALUES(50,'04-05-2019')
INSERT INTO @TestDemo VALUES(50,'04-05-2019')
SELECT COUNT(record) record, DATENAME(MONTH,[month]) Month FROM @TestDemo
WHERE month BETWEEN DATEADD(month, -12, GETDATE()) AND GETDATE()
GROUP BY Month
Output
| record |
Month |
| 1 |
May |
| 1 |
June |
| 1 |
January |
| 4 |
April |
