sql 语句

查询每个月 每天的数量

SELECT COUNT(*),SUBSTR(t.created_at,1,10)  FROM users t WHERE  t.created_at LIKE '2014-04%' GROUP BY SUBSTR(t.created_at,1,10);