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