select asset_name,
asset_id,
count(distinct(address)) as Wallets,
sum(amount) as Tokens,
sum(amount)*50 as USD_value
from algorand.account_asset
where asset_name like 'Lofty %'
AND amount >= 1
AND asset_name <> 'Lofty AI'
group by asset_id,asset_name
order by sum(amount) DESC