MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tbl (
id int,
status varchar(5),
`date` date
);
insert into tbl values
  (1, 'true' , '2019-12-30'),
  (2, 'true' , '2019-11-01'),
  (3, 'false', '2020-01-01'),
  (4, 'true' , '2020-01-01')
;
select * from tbl;


id
status
date


1
true
2019-12-30

2
true
2019-11-01

3
false
2020-01-01

4
true
2020-01-01


SELECT count(id) count_id
  FROM tbl
  WHERE status = 'true'
    AND date >= now() - interval 30 day
;


count_id


2

id	status	date
1	true	2019-12-30
2	true	2019-11-01
3	false	2020-01-01
4	true	2020-01-01