WITH investors AS (SELECT address, COUNT(asset_id) as count_of_assets_invested_in
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 COUNT(address) as Users_that_have_invested_in_atleast_one_property
FROM investors