Действительно Перечисляет <>.IndexOf, выдерживают сравнение ссылкой или значением?

Я заметил ошибку в моем предыдущем примере, так что вот обновление. ПРИМЕЧАНИЕ: запрос сравнивает текущую неделю с предыдущей. Я надеюсь, что это то, что вам нужно.

SELECT
    Date,
    SUM(CASE week WHEN 0 THEN accounts_credited ELSE 0 END) AS 'Accounts credited',
    SUM(CASE week WHEN 0 THEN total_credited ELSE 0 END) AS 'Total Credited',
    100 * (
        SUM(CASE week WHEN 0 THEN total_credited ELSE 0 END) - SUM(CASE week WHEN 1 THEN total_credited ELSE 0 END)
    ) / SUM(CASE week WHEN 1 THEN total_credited ELSE 0 END) AS 'Difference in %'
FROM
(SELECT
    DATE_FORMAT(created, '%Y-%m-%d') as 'Date',
    COUNT(id) AS 'accounts_credited',
    SUM(withdrawal) 'total_credited',
    0 AS 'week'
FROM 
    statements
WHERE 
    status_id IN ('OPEN','PENDING')
AND
    YEARWEEK(created, 1) = YEARWEEK(CURDATE(), 1)
GROUP BY 
    DATE(created)
UNION
SELECT
    DATE_FORMAT(created, '%Y-%m-%d') as 'Date',
    COUNT(id) AS 'accounts_credited',
    SUM(withdrawal) 'total_credited',
    1 AS 'week'
FROM 
    statements
WHERE 
    status_id IN ('OPEN','PENDING')
AND
    (
    DATE(created) >= CURDATE() - INTERVAL DAYOFWEEK(CURDATE())+6 DAY
    AND 
    DATE(created) < CURDATE() - INTERVAL DAYOFWEEK(CURDATE())-1 DAY
    )
GROUP BY 
    DATE(created)
) AS tmp
ORDER BY Date
GROUP BY Date