select distinct PROJECT_NAME ---label.ADDRESS ,upper(split(split(ADDRESS_NAME,':')[1],'l')[0]) as token ,DECIMALS ,ADDRESS_NAME
from
optimism.core.dim_labels label --inner join optimism.core.dim_contracts as con
--on con.address =label.address
where LABEL_SUBTYPE ='bridge'