with mint as
(select BLOCK_TIMESTAMP, NFT_TO_ADDRESS ,TOKENID ,MINT_PRICE_ETH ,MINT_PRICE_USD ,NFT_COUNT ,TX_FEE,tx_hash
from ethereum.core.ez_nft_mints
where NFT_ADDRESS=lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
and EVENT_TYPE ='nft_mint'
and PROJECT_NAME='doodles'
and NFT_FROM_ADDRESS='0x0000000000000000000000000000000000000000')
select
SUM(TX_FEE) AS "FEE paid in ETH" ,
'https://debank.com/profile/' || NFT_TO_ADDRESS as minter ,
count(distinct tx_hash) as "transactions" ,
count(distinct TOKENID) as "NFT minted" ,
sum(MINT_PRICE_ETH) as "ETH paid" ,
SUM(MINT_PRICE_USD) AS "USD paid"
FROM MINT GROUP BY 2 order by 1 desc limit 10