count(asset_id) as total_properties,

sum(total_supply*50) as total_value,

Total_value/total_properties as Average_value

from flipside_prod_db.algorand.asset

where creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'

and asset_name <> 'Lofty AI'

and asset_name like 'Lofty %'