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 |