PapasotLofty
    Updated 2022-03-02
    with asset_id as (
    select asset_id
    from algorand.asset
    where creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA' AND
    asset_name like 'Lofty %')


    SELECT c1.asset_name AS name, sum(c2.total_supply) AS supply, sum(c2.total_supply)*50 AS property_value_USD
    FROM algorand.account_asset AS c1
    INNER JOIN algorand.asset AS c2
    ON c1.asset_id = c2.asset_id
    where c1.asset_id in (select asset_id from asset_id)
    group by c1.asset_name
    order by supply DESC
    Run a query to Download Data