alirsLofty-part-04
Updated 2022-07-14
9
1
2
3
4
5
6
7
8
9
›
⌄
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