ZSaed1. Pooly total
    Updated 2022-06-22
    select
    count(DISTINCT tx_hash) as txs,
    count(DISTINCT NFT_TO_ADDRESS) as minter,
    count(DISTINCT TOKENID) as nfts,
    sum(MINT_PRICE_USD) as volumeu_usd,
    sum(MINT_PRICE_ETH) as volumeu_eth,
    case
    when NFT_ADDRESS = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' then 'Pooly Supporter'
    when NFT_ADDRESS = '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' then 'Pooly Lawyer'
    when NFT_ADDRESS = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523' then 'Pooly Judge'
    end as group_
    from ethereum.core.ez_nft_mints

    where

    NFT_ADDRESS in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed'-- Pooly - Supporter 3,650 remaining of 10,000
    , '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' -- Pooly - Lawyer 712 remaining of 1,000
    , '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523'--Pooly - Judge 9 remaining of 10
    )
    and EVENT_TYPE ='nft_mint'
    group by group_

    Run a query to Download Data