WITH terra_source AS (
select tx_id, msg_value, block_timestamp AS TX_TIME
from terra.msgs
where msg_value:contract = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
and msg_value:execute_msg:initiate_transfer is not null
and TX_STATUS = 'SUCCEEDED'
AND block_timestamp > '2021-09-01'
)
SELECT msg_value:execute_msg:initiate_transfer:recipient_chain AS recipient_chain, COUNT(tx_id) AS Number_of_Transactions FROM terra_source
WHERE recipient_chain != 3
GROUP BY recipient_chain ORDER BY recipient_chain ASC