mysql获取今天、近一周、近一个月的数据

mysql获取今天、近一周、近一个月的数据，直接上代码

SELECT a.* ,b.*,c.* FROM  (SELECT COUNT(1) AS todays FROM jenkins_data a WHERE TO_DAYS(a.commitTime) = TO_DAYS(NOW())) a  //今天
            INNER JOIN (SELECT COUNT(1) AS weeks FROM jenkins_data b WHERE b.commitTime > DATE_SUB(CURDATE(), INTERVAL 1 WEEK)) b //近一周
            INNER JOIN (SELECT COUNT(1) AS months FROM jenkins_data c WHERE c.commitTime > DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) c //近一个月