lagandispensertotal wallets with more than 1 ALGO
    Updated 2022-06-14
    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




    Run a query to Download Data