By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH `Report`( ID, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday ) AS
(
SELECT 1, 'ALL','ALL','ALL', 'ALL',NULL, NULL,'ALL' UNION ALL
SELECT 2, 'ALL','ALL','ALL','ALL',NULL, NULL, NULL
)
SELECT Id, COUNT(Monday='ALL') + COUNT(Tuesday='ALL') + COUNT(Wednesday='ALL') +
COUNT(Thursday='ALL') + COUNT(Friday='ALL') + COUNT(Saturday='ALL')+
COUNT(Sunday='ALL') AS Count
FROM `Report`
GROUP BY Id ;
| Id | Count |
|---|---|
| 1 | 5 |
| 2 | 4 |