WITH total AS(
SELECT
COUNT (aa.address) AS "Total Number Of New wallets"
FROM algorand.account aa
LEFT JOIN algorand.block ab
ON aa.created_at = ab.block_id
WHERE
DATE(block_timestamp) BETWEEN '2022-05-01' AND '2022-05-31'
),
MoreThanOne AS (
SELECT
COUNT (aa.address) AS " New wallets With More Than 1 ALGOs"
FROM algorand.account aa
LEFT JOIN algorand.block ab
ON aa.created_at = ab.block_id
WHERE
DATE(block_timestamp) BETWEEN '2022-05-01' AND '2022-05-31'
AND
balance > 1
)
SELECT * FROM total, MoreThanOne