Morning and hi all,

Refer to code below how should I loop using for loop : -

SELECT
COUNT(CASE WHEN date_submitted > DATE_ADD( CURDATE(), INTERVAL -10 DAY) AND date_submitted < DATE_ADD( CURDATE(), INTERVAL -09 DAY) AND last_updated > DATE_ADD( CURDATE(), INTERVAL -09 DAY) AND last_updated < DATE_ADD( CURDATE(), INTERVAL -08 DAY) THEN 'Resolved' END ) AS 'DAY -10',
COUNT(CASE WHEN date_submitted > DATE_ADD( CURDATE(), INTERVAL -09 DAY) AND date_submitted < DATE_ADD( CURDATE(), INTERVAL -08 DAY) AND last_updated > DATE_ADD( CURDATE(), INTERVAL -08 DAY) AND last_updated < DATE_ADD( CURDATE(), INTERVAL -07 DAY) THEN 'Resolved' END ) AS 'DAY -09',
COUNT(CASE WHEN date_submitted > DATE_ADD( CURDATE(), INTERVAL -08 DAY) AND date_submitted < DATE_ADD( CURDATE(), INTERVAL -07 DAY) AND last_updated > DATE_ADD( CURDATE(), INTERVAL -07 DAY) AND last_updated < DATE_ADD( CURDATE(), INTERVAL -06 DAY) THEN 'Resolved' END ) AS 'DAY -08',
COUNT(CASE WHEN date_submitted > DATE_ADD( CURDATE(), INTERVAL -07 DAY) AND date_submitted < DATE_ADD( CURDATE(), INTERVAL -06 DAY) AND last_updated > DATE_ADD( CURDATE(), INTERVAL -06 DAY) AND last_updated < DATE_ADD( CURDATE(), INTERVAL -05 DAY) THEN 'Resolved' END ) AS 'DAY -07',
COUNT(CASE WHEN date_submitted > DATE_ADD( CURDATE(), INTERVAL -06 DAY) AND date_submitted < DATE_ADD( CURDATE(), INTERVAL -05 DAY) AND last_updated > DATE_ADD( CURDATE(), INTERVAL -05 DAY) AND last_updated < DATE_ADD( CURDATE(), INTERVAL -04 DAY) THEN 'Resolved' END ) AS 'DAY -06',
COUNT(CASE WHEN date_submitted > DATE_ADD( CURDATE(), INTERVAL -05 DAY) AND date_submitted < DATE_ADD( CURDATE(), INTERVAL -04 DAY) AND last_updated > DATE_ADD( CURDATE(), INTERVAL -04 DAY) AND last_updated < DATE_ADD( CURDATE(), INTERVAL -03 DAY) THEN 'Resolved' END ) AS 'DAY -05',
COUNT(CASE WHEN date_submitted > DATE_ADD( CURDATE(), INTERVAL -04 DAY) AND date_submitted < DATE_ADD( CURDATE(), INTERVAL -03 DAY) AND last_updated > DATE_ADD( CURDATE(), INTERVAL -03 DAY) AND last_updated < DATE_ADD( CURDATE(), INTERVAL -02 DAY) THEN 'Resolved' END ) AS 'DAY -04',
COUNT(CASE WHEN date_submitted > DATE_ADD( CURDATE(), INTERVAL -03 DAY) AND date_submitted < DATE_ADD( CURDATE(), INTERVAL -02 DAY) AND last_updated > DATE_ADD( CURDATE(), INTERVAL -02 DAY) AND last_updated < DATE_ADD( CURDATE(), INTERVAL -01 DAY) THEN 'Resolved' END ) AS 'DAY -03',
COUNT(CASE WHEN date_submitted > DATE_ADD( CURDATE(), INTERVAL -02 DAY) AND date_submitted < DATE_ADD( CURDATE(), INTERVAL -01 DAY) AND last_updated > DATE_ADD( CURDATE(), INTERVAL -01 DAY) AND last_updated < DATE_ADD( CURDATE(), INTERVAL 00 DAY) THEN 'Resolved' END ) AS 'DAY -02',
COUNT(CASE WHEN date_submitted > DATE_ADD( CURDATE(), INTERVAL -01 DAY) AND date_submitted < CURDATE() AND last_updated > DATE_ADD( CURDATE(), INTERVAL 00 DAY) AND last_updated < DATE_ADD( CURDATE(), INTERVAL 01 DAY) THEN 'Resolved' END ) AS 'DAY -01'
FROM my_basket
WHERE status >= 80


Tq...

Anybody help ?