Mysql——一段时间内的记录

1.查询一段时间的记录
SELECT count(*) FROM gt_activity WHERE   activity_type=${type} and (create_time  between '${firstDay}' and '${lastDay}' )

2.查询本月

活动总数（本月）
SELECT count(*) FROM gt_activity WHERE DATE_FORMAT( create_time, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' )

3.本年

select  count(*) from gt_activity where YEAR(create_time)=YEAR(NOW());