SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE transactions(
  customer_id integer,
  customer_name varchar(100),
  transaction_date date,
  transaction_amount integer
);

INSERT INTO transactions(customer_id, customer_name, transaction_date, transaction_amount)
VALUES
(1, 'Home Depot', '1/1/2022', 500),
(1, 'Home Depot', '1/2/2022', 300),
(2, 'Lowes', '1/1/2022', 100),
(3, 'Ace', '1/1/2022', 300),
(3, 'Ace', '1/3/2022', 399),
(3, 'Ace', '1/1/2022', 300),
(3, 'Ace', '1/2/2022', 300),
(2, 'Lowes', '5/3/2022', 400),
(4, 'Target', '1/1/2021', 500),
(4, 'Target', '1/1/2022', 500),
(4, 'Target', '2/22/2022', 700)
11 rows affected

WITH t(t_id, customer_id, customer_name, transaction_date, transaction_amount)
AS(
    SELECT row_number() OVER (ORDER BY transaction_date) as t_id,
    customer_id,
    customer_name,
    transaction_date,
    transaction_amount
    FROM 
        transactions
)
SELECT DISTINCT 
    t.customer_id, 
    t.customer_name
FROM
	t
JOIN 
	t as tt on t.customer_id = tt.customer_id AND t.t_id <> tt.t_id AND ABS(DATEDIFF(day, t.transaction_date, tt.transaction_date)) <= 60
	


customer_id
customer_name


3
Ace

1
Home Depot

4
Target


SELECT datediff(day, '5/3/2022', '1/1/2022')


(No column name)


-122