一个查询，查询》30，》60，》90天的记录

SELECT
    dealer_name,
    sum(c1) thirty_day,
    sum(c2) sixty_day,
    sum(c3) ninty_day,
    sum(c4) over_day
FROM
    (
        SELECT
            t1. NAME dealer_name,
            car.id,
            operate_time,
            DATEDIFF(SYSDATE(), operate_time) td,
            CASE
        WHEN DATEDIFF(SYSDATE(), operate_time) <= 30 THEN
            1
        ELSE
            0
        END c1,
        CASE
    WHEN DATEDIFF(SYSDATE(), operate_time) > 30
    AND DATEDIFF(SYSDATE(), operate_time) <= 60 THEN
        1
    ELSE
        0
    END c2,
    CASE
WHEN DATEDIFF(SYSDATE(), operate_time) > 60
AND DATEDIFF(SYSDATE(), operate_time) <= 90 THEN
    1
ELSE
    0
END c3,
 CASE
WHEN DATEDIFF(SYSDATE(), operate_time) > 90 THEN
    1
ELSE
    0
END c4
FROM
    t_dealer t1,
    t_car car,
    t_car_operate_log t3
WHERE
    car.id = t3.car_id_fk
AND car.dealer_id_fk = t1.id
AND car. STATUS = t3.content
AND car. STATUS != '0'
AND car. STATUS != 'A'
AND car. STATUS != 'B'
AND car. STATUS != 'C'
AND car. STATUS != 'E'
AND car.car_type = '0'
    ) m
GROUP BY
    dealer_name