1

select count(id) from table where date_sub(curdate(), interval 7 day) <= date(CREATE_TIME)

1

select count(id) from table where date_sub(curdate(), interval 6 month) <= date(CREATE_TIME)

1

select count(id) from table where date_sub(curdate(), interval 1 year) <= date(CREATE_TIME)

1

select count(id) from table where DATE_FORMAT(NOW(),'%Y-%m') == DATE_FORMAT(CREATE_TIME,'%Y-%m')