SQL Server 2022

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

create table mytable (
  ColumnA  varchar(20),
  ColumnB  varchar(20),
  ColumnC  varchar(20),       
  ColumnD  varchar(20),
  datecreate datetime
);

insert into mytable values
('cust_001',    'IDR',     'personal',        'active',  '2023-12-24 00:00:00.000'),
('cust_001',    'JPY',     'personal',        'active',  '2023-08-11 00:00:00.000'),
('cust_001',    'USD',     'personal',        'active',  '2024-01-07 00:00:00.000'),
('cust_002',    'SAR',     'company' ,        'active',  '2023-01-01 00:00:00.000'),
('cust_002',    'SGD',     'company' ,        'active',  '2023-10-11 00:00:00.000'),
('cust_003',    'CAD',     'company' ,        'active',  '2024-01-01 00:00:00.000'),
('cust_004',    'IDR',     'company' ,        'active',  '2024-01-05 00:00:00.000'),
('cust_004',    'SAR',     'company' ,        'active',  '2024-01-03 00:00:00.000'),
('cust_005',    'EUR',     'company' ,        'active',  '2024-01-09 00:00:00.000');
9 rows affected

insert into mytable values
('cust_006', 'EUR', 'company', 'active', '2023-01-09 00:00:00.000'); 
1 rows affected

SELECT columna, columnc, ColumnD, COUNT(*)
FROM mytable
WHERE datecreate >= DATEADD(MONTH, -3, GETDATE())
GROUP BY columna, columnc, ColumnD 


columna
columnc
ColumnD
(No column name)


cust_001
personal
active
2

cust_002
company
active
1

cust_003
company
active
1

cust_004
company
active
2

cust_005
company
active
1


SELECT columna, columnc, ColumnD, 
       COUNT(CASE WHEN datecreate >= DATEADD(MONTH, -3, GETDATE()) THEN 1 END)
FROM mytable
GROUP BY columna, columnc, ColumnD 


columna
columnc
ColumnD
(No column name)


cust_001
personal
active
2

cust_002
company
active
1

cust_003
company
active
1

cust_004
company
active
2

cust_005
company
active
1

cust_006
company
active
0


Warning: Null value is eliminated by an aggregate or other SET operation.

columna	columnc	ColumnD	(No column name)
cust_001	personal	active	2
cust_002	company	active	1
cust_003	company	active	1
cust_004	company	active	2
cust_005	company	active	1