WITH Time as(
SELECT
block_timestamp,
block_id
FROM algorand.block
WHERE block_timestamp >= '2022-05-01' --since May
AND block_timestamp < '2022-06-01' --since May
),
Addresses as(
SELECT
ADDRESS,
CREATED_AT,
BALANCE
FROM algorand.account
)
SELECT
CASE
WHEN BALANCE >=1 THEN 'WALLETS WITH MORE THAN ONE ALGO'
ELSE 'WALLETS WITH LESS THAN ONE ALGO'
END AS BALANCE,
COUNT(DISTINCT A.ADDRESS) AS New_wallets
FROM Addresses A INNER JOIN Time T ON A.CREATED_AT=T.block_id
WHERE T.block_timestamp::DATE >= '2022-05-01' -- may
AND T.block_timestamp::DATE < '2022-06-01'
GROUP BY 1
--ORDER BY ASC