MySQL之统计某个对象分别在30天内、30天到60天的金额

SELECT
    object_id,
    SUM(CASE
        WHEN date_column >= CURDATE() - INTERVAL 30 DAY AND date_column < CURDATE() THEN amount
        ELSE 0
    END) AS amount_30_days,
    SUM(CASE
        WHEN date_column >= CURDATE() - INTERVAL 60 DAY AND date_column < CURDATE() - INTERVAL 30 DAY THEN amount
        ELSE 0
    END) AS amount_30_to_60_days
FROM your_table
WHERE object_id = 'your_object_id'
GROUP BY object_id