SELECT
ASSET_ID,
ASSET_NAME,
TOTAL_SUPPLY,
50 * TOTAL_SUPPLY AS total_token_investment_price, -- each part valued 50 USD
ASSET_URL
FROM algorand.asset
WHERE CREATOR_ADDRESS='LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA' --LoftyAI address
AND TOTAL_SUPPLY <> 0
AND ASSET_ID <> 237267329 --Except loftyAI
AND ASSET_URL IS NOT NULL -- removing noises
ORDER BY 3 DESC