select

nft_address,

count(*) as sales

from optimism.core.ez_nft_sales as a

left join optimism.core.dim_labels as l on l.address = a.nft_address

group by 1)

select

count(nft_address) NFT_Collections,

sum(sales) as Total_Sales

from total_sales