数据库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