princefarzamThe number of investors that bought at least one properties
    Updated 2022-06-30
    WITH assetID AS (SELECT
    ASSET_ID,
    ASSET_NAME,
    50 * TOTAL_SUPPLY AS total_token_investment_price -- each part valued 50 USD
    FROM algorand.asset
    WHERE CREATOR_ADDRESS='LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    AND TOTAL_SUPPLY <> 0
    AND ASSET_ID <> 237267329 --Except loftyAI
    AND ASSET_URL IS NOT NULL -- removing noises
    ORDER BY 3 DESC)

    SELECT
    COUNT(DISTINCT A.ADDRESS) AS Investors

    FROM algorand.account_asset A INNER JOIN assetID ID ON A.ASSET_ID = ID.ASSET_ID
    WHERE A.AMOUNT >= 1
    AND A.ADDRESS <> 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA' --Excluding LoftyAI address
    Run a query to Download Data