with tab1 as (

select ORIGIN_FROM_ADDRESS as bridger

from ethereum.defi.ez_bridge_activity

where DESTINATION_CHAIN='avalanche c-chain'

and PLATFORM='synapse'

and BLOCK_TIMESTAMP::date>='2023-10-19'

),

tab2 as (

select

ORIGIN_FROM_ADDRESS

,ORIGIN_TO_ADDRESS

,TX_HASH

from avalanche.core.ez_token_transfers

where BLOCK_TIMESTAMP::date>='2023-10-19'

),

tab3 as (

select ADDRESS

,LABEL_TYPE

,PROJECT_NAME

from avalanche.core.dim_labels

select LABEL_TYPE

,case

when LABEL_TYPE='dex' then 'DEX'

when LABEL_TYPE='defi' then 'DEFI'

when LABEL_TYPE='nft' then 'NFT'

when LABEL_TYPE='bridge' then 'BRIDGE'

else 'OTHERS' end as int

,count(distinct TX_HASH) as txs

from tab2

left join tab3

on tab2.ORIGIN_TO_ADDRESS=tab3.ADDRESS

and ORIGIN_FROM_ADDRESS in (select bridger from tab1)

where LABEL_TYPE is not null

group by 1