日期加总SQL语句

select date_format(CREATEDAY,'%Y-%m-%d') as dates,count(*) as counts from members group by date_format(CREATEDAY,'%Y-%m-%d')

以上SQL统计每日新增会员数。