Query Run
SELECT CONCAT(LEFT(log_timestamp, 4), '-', SUBSTR(log_timestamp, 5, 2)) AS... 1 year ago