SELECT
SUM(secondLuckNumber) ,#每天字段secondLuckNumber的和
DATE_FORMAT(time, '%Y%m%d') days
FROM
records
GROUP BY
days DESC #从最新开始显示
SELECT
count(*)
FROM
(
SELECT
SUM(secondLuckNumber) - SUM(firstLuckNumber) + count(firstLuckNumber),
DATE_FORMAT(time, '%Y%m%d') days
FROM
records
GROUP BY
days DESC
) AS tmp
#统计上述查询结果的数量