Query Run
SELECT LEFT(log_timestamp, 4) as year, COUNT(*) FROM logging WHERE... 7 years ago
SELECT LEFT(log_timestamp, 6) as month, COUNT(*) FROM logging WHERE... 7 years ago