princefarzamThe number of properties that each investor has
    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
    A.ADDRESS AS Investors,
    COUNT(A.AMOUNT) AS The_Number_of_properties,
    The_Number_of_properties*50 AS The_value_of_properties
    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
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10
    Run a query to Download Data