Query Run
SELECT SUBSTR(log_timestamp,1,8) AS AAAAMMDD, COUNT(*) as... 1 year ago