with mint as

(select BLOCK_TIMESTAMP, NFT_TO_ADDRESS ,TOKENID ,ERC1155_VALUE ,tx_hash

from base.nft.ez_nft_transfers

where

EVENT_TYPE='mint' and

NFT_ADDRESS='0xbdb1a8772409a0c5eeb347060cbf4b41dd7b2c62' and

NFT_FROM_ADDRESS='0x0000000000000000000000000000000000000000'

)

select

count(distinct NFT_TO_ADDRESS) as "Minters" ,

count(distinct tx_hash) as "Mint Transactions" ,

count(distinct TOKENID) as "NFT" ,

sum(ERC1155_VALUE) as "ETH"

FROM MINT