FROM algorand.account_asset

WHERE asset_id in (select asset_id from algorand.asset where creator_address =

'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA' AND asset_deleted = 'FALSE')

AND asset_closed = 'FALSE'

AND address != 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'

GROUP BY address

ORDER BY count_of_assets_invested_in DESC)

SELECT *

FROM investors

WHERE count_of_assets_invested_in in (SELECT max(count_of_assets_invested_in) FROM investors)