with Dex_addresses as (
SELECT
'Ethereum' as chain,
address,
label as DEX_Name
from ethereum.core.dim_labels
where LABEL_TYPE ilike 'dex'
union ALL
select
'Solana' as chain,
address,
label as DEX_Name
from solana.core.dim_labels
where LABEL_TYPE ilike 'dex'
union ALL
select
'Binance Smart Chain' as chain,
address,
PROJECT_NAME as DEX_Name
from bsc.core.dim_labels
where LABEL_TYPE ilike 'dex'
union all
select
'Polygon' as chain,
address,
PROJECT_NAME as DEX_Name
from polygon.core.dim_labels
where LABEL_TYPE ilike 'dex'
)
,