MySQL 8.0

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

Create Table table_name(sale_id INT, status INT);

Insert Into table_name Values(268,5),
(268,1),
(268,1),
(268,1),
(283,5),
(283,5),
(283,5),
(284,5),
(284,1),
(284,1),
(284,1),
(284,1),
(284,1),
(284,1);

Records: 14  Duplicates: 0  Warnings: 0


SELECT sale_id,
       CASE WHEN COUNT(*) = COUNT(CASE status WHEN 5 THEN 1 END)
            THEN 'expired'
            ELSE 'active'
       END AS activity
FROM table_name
GROUP BY sale_id
ORDER BY sale_id;


sale_id
activity


268
active

283
expired

284
active


SELECT T.sale_id,
       CASE WHEN EXISTS(SELECT 1 FROM table_name D WHERE D.sale_id = T.sale_id AND D.status<>5)
            THEN 'active'
            ELSE 'expired'
       END AS activity
FROM table_name T
GROUP BY T.sale_id
ORDER BY sale_id;


sale_id
activity


268
active

283
expired

284
active