alirsLofti-part-05
Updated 2022-07-14
9
1
2
3
4
5
6
7
›
⌄
Select asset_id, asset_name, sum(amount) * 50 as total_amount_raised_in_USD
from algorand.account_asset
where amount > 0 and asset_id != '237267329' and asset_id in (select asset_id
from algorand.asset
where creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA')
group by 1, 2
order by total_amount_raised_in_USD desc
Run a query to Download Data