from crosschain.core.dim_contracts ---polygon.core.ez_nft_sales --ethereum.core.ez_nft_sales

where name like 'element'

_________________________________

select * --DISTINCT NAME--platform_name

from crosschain.core.address_labels

where

PROJECT_NAME like 'element' AND LABEL_TYPE LIKE 'dapp'

select --DISTINCT NAME--platform_name

from crosschain.core.dim_contracts

where

NAME like 'element' OR SYMBOL LIKE 'Element'

select --DISTINCT NAME--platform_name

from polygon.core.dim_contracts

where

NAME like 'element' OR SYMBOL LIKE 'Element'

select --DISTINCT NAME--platform_name

from avalanche.core.dim_labels

where

PROJECT_NAME like 'element'-- OR SYMBOL LIKE 'Element'

select --DISTINCT NAME--platform_name

from bsc.core.dim_contracts

where

NAME like 'element' OR SYMBOL LIKE 'Element'