select CONTRACT_NAME ,CREATED_AT_TIMESTAMP, MINT as token_id_contract , IMAGE_URL ,TOKEN_ID , TOKEN_METADATA

from

solana.core.dim_nft_metadata

where (CONTRACT_NAME) ilike '%Dapper Ape High Society%'

, b as

select MINT ,PURCHASER as minter ,MINT_PRICE , fv.tx_id , datas.* ,FEE/pow(10,9) as FEE ,fv.SUCCEEDED

from

solana.core.fact_nft_mints as fv inner join datas on token_id_contract = MINT

inner join solana.core.fact_transactions as fc on fc.tx_id =fv.tx_id

where fv.SUCCEEDED ='TRUE' and MINT_CURRENCY ='So11111111111111111111111111111111111111111' )

select

count(distinct MINTER) as minters ,

count(distinct tx_id) as txhash ,

count(distinct TOKEN_ID) as NFT_minted ,

sum(MINT_PRICE) as sol ,

SUM(fee) AS FEE ,

avg(MINT_PRICE) as avgsol ,

avg(FEE) AS avgFEE ,SUCCEEDED

from b

group by SUCCEEDED