princefarzamRank the properties listed by LoftyAI based on total token investment price
    Updated 2022-06-30
    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
    Run a query to Download Data