SELECT

asset_id

from flipside_prod_db.algorand.asset

where creator_Address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'

and asset_deleted = FALSE

),

raw1 as (

SELECT

asset_id,

asset_name,

sum(amount) as amnt

from flipside_prod_db.algorand.account_asset

where amount > 0

and asset_id <> '237267329'

and address <> 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'

GROUP by 1,2

)

asset_name,

amnt as shares,

amnt * 50 as usd_value

from raw1 x join raw0 y on x.asset_id=y.asset_id

ORDER by 2