SELECT * from optimism.core.dim_labels

inner join optimism.core.ez_nft_sales

on nft_address = address

select project_name, count(DISTINCT tx_hash) as no_of_txns,

count(distinct buyer_address) as no_of_buyers,

count(distinct seller_address) as no_of_sellers,

round(sum(price),2) as total_sales_volume,

sum(price_usd) as total_sales_volume_usd,

count(distinct tokenid) as no_of_nfts_sold

from optimism_nfts

where event_type = 'sale'

GROUP by project_name

order by no_of_txns desc