address,

sum(amount) as "Token amount",

count(distinct asset_id) as "Number of different properties",

sum(amount) * 50 as "Investment amount (USD)"

from algorand.account_asset

where asset_id in (select asset_id

from algorand.asset

where creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA')

group by 1

order by 2 desc