select

Date_trunc('Day',First_mint_date)::DATE AS Day,

count(Minter) AS M,

sum(M) over (order by Day) AS "Total Minters"

from (

select

NFT_TO_ADDRESS AS Minter,

min(BLOCK_TIMESTAMP) AS First_mint_date

from avalanche.core.ez_nft_transfers

where nft_address ='0x3025c5c2aa6eb7364555aac0074292195701bbd6'

and NFT_FROM_ADDRESS='0x0000000000000000000000000000000000000000'

group by 1

) group by 1),

main AS (

select

Date_trunc('Day',BLOCK_TIMESTAMP)::DATE AS Day,

count(*) AS Mints,

sum(Mints) over (order by Day) AS "Total Mints",

count(DISTINCT NFT_TO_ADDRESS) AS Minters,

Mints/Minters AS "Average Mints by Minters"

from avalanche.core.ez_nft_transfers

where nft_address ='0x3025c5c2aa6eb7364555aac0074292195701bbd6'

and NFT_FROM_ADDRESS='0x0000000000000000000000000000000000000000'

group by 1)

select

Day,

Mints,

"Total Mints",

Minters,

"Average Mints by Minters",

from main inner join new using(Day)