Query Run
select cast(substr(log_timestamp, 1, 8 ) as date) 'date', count(*) from... 1 year ago