MariaDB 10.3

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

CREATE TABLE operations (

id int auto_increment primary key,

campaign VARCHAR(255),

country VARCHAR(255),

sales_status VARCHAR(255),

quantity INT

);

INSERT INTO operations

(campaign, country, sales_status, quantity

)

VALUES

("C001", "DE", "demand", "100"),

("C001", "US", "shipped", "300"),

("C001", "NL", "shipped", "700"),

("C001", "FR", "shipped", "400"),

("C002", "DE", "demand", "500"),

("C002", "US", "demand", "900"),

("C002", "FR", "shipped", "200"),

("C003", "US", "demand", "600"),

("C003", "NL", "demand", "250"),

("C003", "FR", "demand", "150"),

("C003", "PL", "demand", "550"),

("C004", "DE", "shipped", "825"),

("C004", "PL", "shipped", "462");

SELECT

campaign,

(CASE WHEN MAX(sales_status = 'shipped') OVER (PARTITION BY campaign) = 1

THEN 'shipped' ELSE sales_status END) AS sales_status,

SUM(quantity)

FROM operations

GROUP BY 1;