sql查询:查询近五日数据(包括当前日)

SELECT
    date_format( cal.EndDate, '%Y-%m-%d' ) AS time,
    COUNT( CASE WHEN cal.Called = '人工坐席'  THEN cal.id END ) AS ordinary,
    COUNT( CASE WHEN cal.Called = '坐席振铃'  THEN cal.id END ) AS ring
FROM
    call_call cal 
WHERE
    cal.EndDate >= date(now()) - INTERVAL 4 DAY 
GROUP BY
    DAY ( cal.EndDate )