例：
SELECT DATE_FORMAT(`create_time`, '%Y-%m-%d') AS days,COUNT(1) AS num FROM `dc_loan_aa_orders` GROUP BY DATE_FORMAT(`create_time`, '%Y-%m-%d') ORDER BY create_time DESC
结果集如下：
