Query Run
select year(rev_timestamp), month(rev_timestamp), count(rev_id) from... 6 months ago
select year(rev_timestamp), month(rev_timestamp), count(*) AS "month" from... 6 months ago