SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select @@version;


(No column name)


Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) 
	Oct  8 2022 05:58:25 
	Copyright (C) 2022 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



CREATE TABLE example 
(
    Ref_date	VARCHAR(512),
    Ref_source	VARCHAR(512)
);

INSERT INTO example (Ref_date, Ref_source) VALUES
	('6/12/2024', 'A'),
	('6/13/2024', 'A'),
	('6/14/2024', 'B'),
	('6/15/2024', 'b');

SELECT * FROM Example


Ref_date
Ref_source


6/12/2024
A

6/13/2024
A

6/14/2024
B

6/15/2024
b


SELECT Ref_Source, year(Ref_date) as [Year], 
    SUM(CASE Month(Ref_date) WHEN 1 THEN 1 ELSE 0 END) as Jan, 
    SUM(CASE Month(Ref_date) WHEN 2 THEN 1 ELSE 0 END) as Feb ,
    SUM(CASE Month(Ref_date) WHEN 3 THEN 1 ELSE 0 END) as Mar,
    SUM(CASE WHEN Month(Ref_date) Between 1 AND 3 THEN 1 ELSE 0 END) as Q1,
    SUM(CASE Month(Ref_date) WHEN 4 THEN 1 ELSE 0 END) as Apr ,
    SUM(CASE Month(Ref_date) WHEN 5 THEN 1 ELSE 0 END) as May ,
    SUM(CASE Month(Ref_date) WHEN 6 THEN 1 ELSE 0 END) as June ,
    SUM(CASE WHEN Month(Ref_date) Between 4 AND 6 THEN 1 ELSE 0 END) as Q2,
    SUM(CASE Month(Ref_date) WHEN 7 THEN 1 ELSE 0 END) as July ,
    SUM(CASE Month(Ref_date) WHEN 8 THEN 1 ELSE 0 END) as Aug ,
    SUM(CASE Month(Ref_date) WHEN 9 THEN 1 ELSE 0 END) as Sep,
    SUM(CASE WHEN Month(Ref_date) Between 7 AND 9 THEN 1 ELSE 0 END) as Q3,
     SUM(CASE Month(Ref_date) WHEN 10 THEN 1 ELSE 0 END) as Oct, 
    SUM(CASE Month(Ref_date) WHEN 11 THEN 1 ELSE 0 END) as Nov ,
    SUM(CASE Month(Ref_date) WHEN 12 THEN 1 ELSE 0 END) as Dec,
    SUM(CASE WHEN Month(Ref_date) Between 10 AND 12 THEN 1 ELSE 0 END) as Q4
FROM Example
GROUP BY ref_source, year(Ref_date)


Ref_Source
Year
Jan
Feb
Mar
Q1
Apr
May
June
Q2
July
Aug
Sep
Q3
Oct
Nov
Dec
Q4


A
2024
0
0
0
0
0
0
2
2
0
0
0
0
0
0
0
0

B
2024
0
0
0
0
0
0
2
2
0
0
0
0
0
0
0
0