数据库Mark.2

select count(*) as count,DATE_SUB('2016-10-04',INTERVAL regDay DAY)

from result_1005

group by

DATE_SUB('2016-10-04',INTERVAL regDay DAY)

ORDER BY COUNT desc