select disposition,count(disposition),day(calldate)from cdr where year(calldate) = '2017' group by day(calldate),disposition 周 select disposition,count(disposition),WEEK(calldate) from cdr where year(calldate) = '2016' group by week(calldate),disposition 月 select disposition,count(disposition),month(calldate) from cdr where year(calldate) = '2016' group by month(calldate),disposition select disposition,count(disposition),DATE_FORMAT(calldate,'%Y-%m') from cdr where calldate BETWEEN'2016-2-10' and '2017-1-1' group by month(calldate),disposition 年 select disposition,count(disposition),year(calldate) from cdr group by year(calldate),disposition