select aa.asset_id, aa.asset_name, sum(aa.amount *50) total_revenue_usd, count(distinct aa.address) total_investors
from algorand.account_asset aa
left join algorand.asset a
on aa.asset_id = a.asset_id
where a.creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
and aa.asset_id != '237267329'
and aa.amount > 0
group by 1,2
order by 3 desc