Query Run
SELECT substr(log_timestamp,1,4) AS AAAA, count(*) AS TOTAL FROM... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAA, COUNT(*) as TOTAL 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