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 |