adambalaTop 10 minter based on tokens number
    Updated 2022-12-09
    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='0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d'
    and EVENT_TYPE ='nft_mint'
    and PROJECT_NAME='boredapeyachtclub'
    and NFT_FROM_ADDRESS='0x0000000000000000000000000000000000000000')

    select

    count(distinct TOKENID) as "NFT minted" ,
    'https://debank.com/profile/' || NFT_TO_ADDRESS as minter ,
    count(distinct tx_hash) as "transactions" ,
    sum(MINT_PRICE_ETH) as "ETH paid" ,
    SUM(MINT_PRICE_USD) AS "USD paid" ,
    SUM(TX_FEE) AS "FEE paid in ETH"
    FROM MINT GROUP BY 2 order by 1 desc limit 10

    Run a query to Download Data