-- forked from Solana NFT mints @ https://flipsidecrypto.xyz/edit/queries/ef7b2627-97e8-4ceb-abf1-0cbdaa5ea898

select b.label,

count(distinct a.PURCHASER) as PURCHASERs,

avg(a.MINT_PRICE) as MINT_PRICE,

case when a.MINT_CURRENCY = 'So11111111111111111111111111111111111111111' then 'SOL' else c.TOKEN_NAME end as MINT_CURRENCY

from solana.core.fact_nft_mints a left join solana.core.dim_labels b on a.mint = b.address

left join solana.core.dim_tokens c on a.MINT_CURRENCY=c.TOKEN_ADDRESS

where b.label = '{{Metrics}}'

group by 1,4