Query Run
SELECT SUBSTR(log_timestamp,1,4) as AAAA, COUNT(*) FROM ... 1 year ago
( SELECT SUBSTR(log_timestamp,1,6), actor_name as 'Usuario',... 1 year ago
( SELECT SUBSTR(log_timestamp,1,6), actor_name as 'Usuario',... 1 year ago
( SELECT SUBSTR(log_timestamp,1,6), actor_name as 'Usuario',... 1 year ago