select
tokenid as "Token",
count(distinct tx_hash) as "Total Number of Mints",
sum (mint_price_usd) as "Total Minted Volume"
from ethereum.core.ez_nft_mints
where block_timestamp >= '2022-01-01' and block_timestamp <= '2022-12-30'
and mint_price_usd > 0 and project_name is not null
GROUP by 1
ORDER by 3 DESC
LIMIT 10