Query Run
SELECT LEFT(log_timestamp, 8) AS 'year-month-day', COUNT(*) FROM... 1 month ago
SELECT LEFT(log_timestamp, 6) AS 'year-month', COUNT(*) FROM logging WHERE... 1 month ago