alirsLofty-part-04
    Updated 2022-07-14
    with total as (select ASSET_ID
    ,ASSET_NAME
    ,TOTAL_SUPPLY
    from algorand.asset
    where creator_address='LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    and TOTAL_SUPPLY>0
    and ASSET_NAME!='Lofty AI'
    order by TOTAL_SUPPLY DESC )
    select sum(total_supply) from total
    Run a query to Download Data