select
Top 3 address as wallet,
count(address) as Lofty_properties,
sum(amount) as tokens,
sum(amount)*50 as USD_investment
from algorand.account_asset
where asset_name like 'Lofty %'
AND address <> 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
group by address
order by count(*) desc