alirsLofti-part-05
    Updated 2022-07-14
    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