case when app_id =233725850 then 'YLDY/ALGO'

when app_id =385089192 then 'YLDY/ARCC'

when app_id =393388133 then 'YLDY/GEMS'

when app_id =424101057 then 'YLDY/XET'

when app_id =447336112 then 'YLDY/CHOICE'

when app_id =511597182 then 'YLDY/AKITA'

when app_id =583357499 then 'YLDY/ARCC pool_2'

when app_id =591414576 then 'YLDY/DEFLY'

when app_id =593126242 then 'YLDY/KTNC'

when app_id =593270704 then 'YLDY/TINY'

when app_id =593289960 then 'YLDY/TREES'

when app_id =596950925 then 'YLDY/HDL'

when app_id =593324268 then 'YLDY/BLOCK'

when app_id =604219363 then 'YLDY/RIO'

when app_id =604373501 then 'YLDY/AO'

when app_id =604392265 then 'YLDY/CHIP'

when app_id =604411076 then 'YLDY/FLAMINGO'

when app_id =609492331 then 'YLDY/WBLN'

when app_id =604434381 then 'YLDY/BIRDS'

when app_id =617707129 then 'YLDY/DPANDA'

when app_id =618390867 then 'YLDY/CURATOR'

when app_id =620458102 then 'YLDY/ACORN'

when app_id =624919018 then 'YLDY/CRSD'

when app_id =625053603 then 'YLDY/NURD'

when app_id =620625200 then 'YLDY/NEKOS'

when app_id =717256390 then 'YLDY/ALCH'

when app_id =710518651 then 'YLDY/COSG'

end as pool_name,

count(distinct b.tx_group_id) as no_stake,

sum(asset_amount/1e6) as volume_yldy,

count (distinct s.SENDER) as no_wallets,

volume_yldy/no_wallets as average_deposit

from algorand.application_call_transaction s left outer join algorand.asset_transfer_transaction b on s.tx_group_id=b.tx_group_id

where s.block_timestamp >= '2022-01-01'

and try_base64_decode_string(s.tx_message:txn:apaa[0]::string) in ('S','stake')