PapasotLofty
Updated 2022-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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