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
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
select LEFT(rev_timestamp,6) as month, user_name, count(*) as... 2 years ago
select LEFT(rev_timestamp,6) as month, user_name, count(*) as... 2 years ago
select LEFT(rev_timestamp,6) as month, count(*) as tag_count ... 2 years ago