select blockchain,

project_name,

address_name

from arbitrum.core.dim_labels

where label_type = 'nft'

union all

select blockchain,

project_name,

address_name

from avalanche.core.dim_labels

where label_type = 'nft'

union all

select blockchain,

project_name,

address_name

from bsc.core.dim_labels

where label_type = 'nft'

union all

select blockchain,

project_name,

address_name

from optimism.core.dim_labels

where label_type = 'nft'

union all

select blockchain,

project_name,

address_name

from polygon.core.dim_labels

where label_type = 'nft'

select blockchain,

count (distinct project_name) as projects,

count (distinct address_name) as addresses

from raw