asset_id,

asset_name,

sum(amount) * 50 as total_amount_raised_in_USD,

sum(amount) as token_amount,

sum(total_amount_raised_in_USD) over () as total_amount_usd,

sum(token_amount) over () as total_asset_amount

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