3 ms·How about: CASE WHEN MIN(express_delivered) = 0 THEN 0 ELSE 1 END AS always_been_express_deliveredby nickpeterson 10y agoHow about: CASE WHEN MIN(express_delivered) = 0 THEN 0 ELSE 1 END AS always_been_express_delivered