Query editor
1SELECT2 blockchain,3 TRY_CAST(DATE_TRUNC('month', creation_time) AS DATE) AS month,4 COUNT(*) AS num_safes5FROM safe.safes_all6WHERE creation_time >= (CURRENT_DATE - INTERVAL '12' month)7GROUP BY 1, 28ORDER BY 1, 2
SELECT
blockchain,
TRY_CAST(DATE_TRUNC('month', creation_time) AS DATE) AS month,
COUNT(*) AS num_safes
FROM safe.safes_all
WHERE creation_time >= (CURRENT_DATE - INTERVAL '12' month)
GROUP BY 1, 2
ORDER BY 1, 2