MySQL by day, by week, by month, by quarter, by year statistics

SELECTCount(ID) fromRd_track_infoWHEREDATE (create_time)<Date_sub (Curdate (), INTERVAL7  Day);SELECTCount(ID) fromRd_track_infoWHEREDATE (create_time)=Date_sub (Curdate (), INTERVAL7  Day);SELECTCount(ID) fromRd_track_infoWHEREDATE (create_time)>Date_sub (Curdate (), INTERVAL7  Day);

/* statistics by day */

SELECT    Count(ID) countnum, DATE (create_time) createtime fromRd_track_infoGROUP  byDATE (create_time)ORDER  byDATE (create_time)DESC;/*statistics by week*/SELECT    Count(ID) countnum, WEEK (create_time) createtime fromRd_track_infoGROUP  byWEEK (create_time)ORDER  byWEEK (create_time)DESC;/*Monthly Statistics*/SELECT    Count(ID) countnum,MONTH(create_time) createtime fromRd_track_infoGROUP  by    MONTH(create_time)ORDER  by    MONTH(Create_time)DESC;/*Statistics by Quarter*/SELECT    Count(ID) countnum, QUARTER (create_time) createtime fromRd_track_infoGROUP  byQUARTER (create_time)ORDER  byQUARTER (create_time)DESC;/*by year statistics*/SELECT    Count(ID) countnum, Year(create_time) createtime fromRd_track_infoGROUP  by     Year(create_time)ORDER  by     Year(Create_time)DESC;

MySQL by day, by week, by month, by quarter, by year statistics