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