project_name,

count(tx_hash) as tx_count,

max (mint_price_usd) as max_voume

from ethereum.core.ez_nft_mints a

left outer join ethereum.core.dim_labels b on a.nft_address = b.address

where block_timestamp >= '2022-01-01' and block_timestamp < '2023-01-01'

and project_name is not null

and mint_price_usd > 0

group by 1

order by 2 DESC

limit 10