count (distinct TX_ID) as num_mints,

count (distinct PURCHASER) as num_minters,

count (distinct MINT) as num_nfts,

sum (MINT_PRICE) as volume,

avg (MINT_PRICE) as price

FROM solana.core.fact_nft_mints

WHERE SUCCEEDED = 'TRUE'

and BLOCK_TIMESTAMP>='2022-01-01'

and MINT_CURRENCY = 'So11111111111111111111111111111111111111111'