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

msg_value:execute_msg:zap_into_strategy:strategy_id::string as pool

from terra.msgs

where msg_value:contract::string = 'terra1leadedadm2fguezmd4e445h6fe337yzq8n2dxf' and msg_value:execute_msg:zap_into_strategy is not null and tx_status = 'SUCCEEDED'

group by 2

order by 1 desc