princefarzamUSDT vs. USDC holders
    Updated 2022-02-10
    WITH USDT_HOLDERS AS (
    SELECT
    COUNT(DISTINCT ADDRESS) AS NUMBER_OF_USDT_HOLDERS
    FROM ALGORAND.ACCOUNT_ASSET
    WHERE ASSET_ID = 312769
    AND AMOUNT IS NOT NULL
    ),
    USDC_HOLDERS AS (
    SELECT
    COUNT(DISTINCT ADDRESS) AS NUMBER_OF_USDC_HOLDERS
    FROM ALGORAND.ACCOUNT_ASSET
    WHERE ASSET_ID = 31566704
    AND AMOUNT IS NOT NULL
    )
    SELECT
    'HOLDERS',
    USDT.NUMBER_OF_USDT_HOLDERS,
    USDC.NUMBER_OF_USDC_HOLDERS
    FROM USDT_HOLDERS USDT FULL OUTER JOIN USDC_HOLDERS USDC

    Run a query to Download Data