Query Run
select substring(rev_timestamp, 1, 6) as month, count(rev_id) from ... 1 day ago
select substring(rev_timestamp, 1, 6) as month, count(rev_id) from ... 1 day ago