Query Run
select concat(substr(log_timestamp, 1, 4), '-', substr(log_timestamp, 5, 2)... 1 month ago