Postgres 13

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

CREATE TABLE mytable
    ("CustomerID" varchar(6), "OrderID" int, "Product Name" varchar(14))
;
    
INSERT INTO mytable VALUES
    ('ABC123', 1426457, 'PRODUCT A'),
    ('ABC123', 1426458, 'WARRANTY CLAIM'),
    ('ABC123', 1426457, 'PRODUCT B'),
    ('DEF456', 1426990, 'PRODUCT A'),
    ('DEF456', 1427500, 'PRODUCT B'),
    
    ('GHI456', 1427500, 'PRODUCT A'),
    ('JKL789', 1427500, 'WARRANTY CLAIM');
    
SELECT * FROM mytable
7 rows affected



CustomerID
OrderID
Product Name


ABC123
1426457
PRODUCT A

ABC123
1426458
WARRANTY CLAIM

ABC123
1426457
PRODUCT B

DEF456
1426990
PRODUCT A

DEF456
1427500
PRODUCT B

GHI456
1427500
PRODUCT A

JKL789
1427500
WARRANTY CLAIM


SELECT
    "CustomerID",
    bool_or("Product Name" = 'WARRANTY CLAIM')
        AND
    bool_or("Product Name" != 'WARRANTY CLAIM')
FROM mytable
GROUP BY "CustomerID"


CustomerID
?column?


GHI456
f

DEF456
f

JKL789
f

ABC123
t


SELECT
    *,
    bool_or("Product Name" = 'WARRANTY CLAIM') OVER (PARTITION BY "CustomerID")
        AND
    bool_or("Product Name" != 'WARRANTY CLAIM') OVER (PARTITION BY "CustomerID")
FROM mytable


CustomerID
OrderID
Product Name
?column?


ABC123
1426457
PRODUCT A
t

ABC123
1426458
WARRANTY CLAIM
t

ABC123
1426457
PRODUCT B
t

DEF456
1426990
PRODUCT A
f

DEF456
1427500
PRODUCT B
f

GHI456
1427500
PRODUCT A
f

JKL789
1427500
WARRANTY CLAIM
f

CustomerID	OrderID	Product Name
ABC123	1426457	PRODUCT A
ABC123	1426458	WARRANTY CLAIM
ABC123	1426457	PRODUCT B
DEF456	1426990	PRODUCT A
DEF456	1427500	PRODUCT B
GHI456	1427500	PRODUCT A
JKL789	1427500	WARRANTY CLAIM