WITH LOFTYASSETS AS (
SELECT
asset_id,
asset_name,
total_supply,
created_at
FROM
algorand.asset
WHERE
creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
AND asset_deleted ='FALSE'
AND asset_id != 237267329 --Lofty AI
)
SELECT
asset_name as Property,
50*total_supply as TokenInvestmentPrice_USD
FROM
LOFTYASSETS
ORDER BY 2 desc