where msg_type like '%MsgMultiSend%' and date(block_timestamp) > DATEADD(month, -2, CURRENT_DATE)

group by date(block_timestamp))

, s as (select count(*) as sc,date(block_timestamp) as dt from terra.msgs

where msg_type like '%MsgMultiSend%' and date(block_timestamp) > DATEADD(month, -2, CURRENT_DATE) and tx_status='SUCCEEDED'

group by date(block_timestamp))

select (sc/tc) as r ,t.dt as date from t inner join s on t.dt=s.dt