---

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

#统计上述查询结果的数量