Crazy_KidLoftyAI Tokenized Real Estate (Agorand) 2
    Updated 2022-03-03
    WITH investors AS (SELECT address, COUNT(asset_id) as count_of_assets_invested_in
    FROM algorand.account_asset
    WHERE asset_id in (select asset_id from algorand.asset where creator_address =
    'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA' AND asset_deleted = 'FALSE')
    AND asset_closed = 'FALSE'
    AND address != 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    GROUP BY address
    ORDER BY count_of_assets_invested_in DESC)

    SELECT COUNT(address) as Users_that_have_invested_in_atleast_one_property
    FROM investors
    Run a query to Download Data