WITH New_wallets AS (
SELECT
address
FROM
algorand.account
WHERE
created_at>= 18363444 AND created_at<=18974008 -- 18363444 January first block 18974008 January last block
)
SELECT
count_if(balance != 0) as Addresses_with_ALGO,
count_if(balance = 0) as Addresses_with_zero_ALGO,
Addresses_with_ALGO+Addresses_with_zero_ALGO as Total_addresses
FROM
algorand.account
WHERE
address IN ( SELECT * from New_wallets )