Query Run
select LEFT(rev_timestamp,4) as year, user_name, count(*) as... 2 years ago
select LEFT(rev_timestamp,4) as year, user_name, count(*) as... 2 years ago