MariaDB 10.3

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

CREATE TABLE logistics (
    id int auto_increment primary key,
    campaign VARCHAR(255),
    process_status VARCHAR(255),
    delivery_type VARCHAR(255),
    quantity INT
);

INSERT INTO logistics
(campaign, process_status, delivery_type, quantity
)
VALUES 
("C001", "offer", "fedex", "500"),
("C001", "offer", "fedex", "200"),
("C001", "order", "ubs", "400"),
("C001", "shipped", "ubs", "100"),

("C002", "offer", "fedex", "800"),
("C002", "offer", "fedex", "100"),
("C002", "order", "fedex", "650"),
("C002", "shipped", "fedex", "250"),

("C003", "offer", "fedex", "730"),
("C003", "order", "fedex", "620"),
("C003", "shipped", "dhl", "530"),

("C004", "order", "fedex", "200"),
("C004", "shipped", "fedex", "130"),

("C005", "order", "fedex", "900"),
("C005", "shipped", "ubs", "475"),

("C006", "order", "fedex", "635");
SELECT
campaign
FROM logistics
group by campaign
having max(delivery_type)!=min(delivery_type)


campaign


C001

C003

C005


SELECT 
campaign, process_status, delivery_type, sum(quantity) as quantity
FROM logistics
WHERE campaign IN (
SELECT
campaign
FROM logistics
group by campaign
having max(delivery_type)!=min(delivery_type))
GROUP BY campaign, process_status, delivery_type


campaign
process_status
delivery_type
quantity


C001
offer
fedex
700

C001
order
ubs
400

C001
shipped
ubs
100

C003
offer
fedex
730

C003
order
fedex
620

C003
shipped
dhl
530

C005
order
fedex
900

C005
shipped
ubs
475

campaign	process_status	delivery_type	quantity
C001	offer	fedex	700
C001	order	ubs	400
C001	shipped	ubs	100
C003	offer	fedex	730
C003	order	fedex	620
C003	shipped	dhl	530
C005	order	fedex	900
C005	shipped	ubs	475