distinct CONTRACT_NAME,

count(distinct tx_id) as tx_count,

count(distinct buyer) as buyer,

count(distinct seller) as seller,

sum(price) as price

from flow.core.dim_contract_labels cl join flow.core.ez_nft_sales ns

on cl.event_contract = ns.MARKETPLACE

group by 1