Cacher is the code snippet organizer for pro developers

SELECT 
	(SELECT SUM(quantity)
     FROM `reseller_log` 
	 WHERE type = 'CREATE' AND created_at BETWEEN  DATE_SUB(CURDATE(), INTERVAL 1 DAY ) AND CURDATE()) AS 'one',
    (SELECT SUM(quantity)
     FROM `reseller_log` 
	 WHERE type = 'CREATE' AND created_at BETWEEN  DATE_SUB(CURDATE(), INTERVAL 2 DAY ) AND CURDATE()) AS 'two',
    (SELECT SUM(quantity)
     FROM `reseller_log` 
	 WHERE type = 'CREATE' AND created_at BETWEEN  DATE_SUB(CURDATE(), INTERVAL 3 DAY ) AND CURDATE()) AS 'three',
    (SELECT SUM(quantity)
     FROM `reseller_log` 
	 WHERE type = 'CREATE' AND created_at BETWEEN  DATE_SUB(CURDATE(), INTERVAL 4 DAY ) AND CURDATE()) AS 'four',
    (SELECT SUM(quantity)
     FROM `reseller_log` 
	 WHERE type = 'CREATE' AND created_at BETWEEN  DATE_SUB(CURDATE(), INTERVAL 5 DAY ) AND CURDATE()) AS 'five',
    (SELECT SUM(quantity)
     FROM `reseller_log` 
	 WHERE type = 'CREATE' AND created_at BETWEEN  DATE_SUB(CURDATE(), INTERVAL 6 DAY ) AND CURDATE()) AS 'six',
    (SELECT SUM(quantity)
     FROM `reseller_log` 
	 WHERE type = 'CREATE' AND created_at BETWEEN  DATE_SUB(CURDATE(), INTERVAL 7 DAY ) AND CURDATE()) AS 'seven'
FROM `reseller_log`
GROUP by one