WITH assetID AS (SELECT
ASSET_ID,
ASSET_NAME,
50 * TOTAL_SUPPLY AS total_token_investment_price -- each part valued 50 USD
FROM algorand.asset
WHERE CREATOR_ADDRESS='LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
AND TOTAL_SUPPLY <> 0
AND ASSET_ID <> 237267329 --Except loftyAI
AND ASSET_URL IS NOT NULL -- removing noises
ORDER BY 3 DESC)
SELECT
COUNT(DISTINCT A.ADDRESS) AS Investors
FROM algorand.account_asset A INNER JOIN assetID ID ON A.ASSET_ID = ID.ASSET_ID
WHERE A.AMOUNT >= 1
AND A.ADDRESS <> 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA' --Excluding LoftyAI address