select date_trunc('week',BLOCK_TIMESTAMP) as week

,count(distinct case when TX_STATUS='SUCCESS' then TX_HASH end) as "Success Txs"

,count(distinct case when TX_STATUS not in('SUCCESS') then TX_HASH end) as "Fail Txs"

from base.core.ez_decoded_event_logs

where ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

and EVENT_NAME='LiFiGenericSwapCompleted'

and DECODED_LOG:integrator='layer3'

group by 1