SELECT
DATE_FORMAT( datetime列, '%Y-%m-%d' ) AS 日期,
SUM( ... ) AS 合计,
COUNT( ... ) AS 行数
FROM
表
GROUP BY
DATE_FORMAT( datetime列, '%Y-%m-%d' )
