select distinct tx_id, *

from terra.msgs

where msg_module = 'wasm'

and msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

select msg_value:execute_msg::string as deposit,

sum(msg_value:coins[0]:amount/1e6) as amount_dep,

msg_value:sender::string as sender

from all_tx

where msg_value:coins[0]:denom = 'uusd'

and deposit like '%deposit%'

and tx_status != 'FAILED'

and msg_value:sender::string = 'terra1k8542s5ke56dth7zk4at3vq4aqsst49flfm0wk'

group by 1,3

limit 100