Papasotlofty wallets mode (Max. # of real estate)
    Updated 2023-01-03
    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

    Run a query to Download Data