Query Run
SELECT SUBSTR(log_timestamp,1,4) AS AAAA, COUNT(*) as TOTAL_thanks ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAA, COUNT(*) as TOTAL_thanks ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAA, COUNT(*) as TOTAL_thanks ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAA, COUNT(*) as TOTAL_thanks ... 1 year ago
SELECT SUBSTR(log_timestamp,1,6) AS AAAAMM, COUNT(*) as TOTAL FROM ... 1 year ago