WITH r as (
SELECT rev_page, substring(rev_timestamp, 1, 8) date
FROM... |
1 year ago |
WITH r as (
SELECT rev_page, substring(rev_timestamp, 1, 8) date
FROM... |
1 year ago |
WITH r as (
SELECT rev_page, substring(rev_timestamp, 1, 8) date
FROM... |
1 year ago |
SELECT count(distinct(rev_page))#rev_page, substring(rev_timestamp, 1, 8)... |
1 year ago |
SELECT count(distinct(rev_page))#rev_page, substring(rev_timestamp, 1, 8)... |
1 year ago |
SELECT count(distinct(rev_page))#rev_page, substring(rev_timestamp, 1, 8)... |
1 year ago |
SELECT count(distinct(rev_page))#rev_page, substring(rev_timestamp, 1, 8)... |
1 year ago |
SELECT rev_page, substring(rev_timestamp, 1, 8) date, count(*)... |
1 year ago |