Query Run
SELECT LEFT(rev_timestamp, 4) AS year, COUNT(*) AS n FROM... 7 years ago
SELECT LEFT(rev_timestamp, 6) AS month, page_namespace, COUNT(*) AS n FROM... 7 years ago