WITH
AD (ADDRESS,CREATED_AT, BALANCE) AS (
SELECT ADDRESS, CREATED_AT, BALANCE FROM flipside_prod_db.algorand.account WHERE BALANCE > 1
)
SELECT
COUNT(*) AS CREATED_IN_MAY
FROM
AD
JOIN flipside_prod_db.algorand.block ON AD.CREATED_AT = BLOCK_ID
WHERE
BLOCK_TIMESTAMP BETWEEN '2022-05-01' AND '2022-05-31'