Query Run
select max(c) from ( select count(*) c from ... 1 month ago
select max(c) from ( select count(*) c from ... 1 month ago