mysql 有一个表ABC的字段time为时间戳格式，统计近8天的每天的记录数

SELECT   
    DATE_FORMAT(FROM_UNIXTIME(create_time), '%Y-%m-%d') AS date,  
    COUNT(*) AS record_count  
FROM   
    ABC
WHERE   
    TIMESTAMPDIFF(DAY, FROM_UNIXTIME(create_time), CURDATE()) <= 8  
GROUP BY   
    date  
ORDER BY   
    date;