with cextable as (

select distinct address from crosschain.core.address_labels

where label_type = 'cex' and blockchain in ('ethereum','avalanche','arbitrum','binance smart chain','bsc','optimism','polygon')

union ALL

select distinct address from ethereum.core.dim_labels

where label_type = 'cex'

union all

select distinct address from arbitrum.core.dim_labels

where label_type = 'cex'

union ALL

select distinct address from avalanche.core.dim_labels

where label_type = 'cex'

union ALL

select distinct address from bsc.core.dim_labels

where label_type = 'cex'

union ALL

select distinct address from optimism.core.dim_labels

where label_type = 'cex'

union ALL

select distinct address from polygon.core.dim_labels

where label_type = 'cex')

select 'Ethereum' as chain,