(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')

, DETAIL AS

(select

NFT_TO_ADDRESS ,

count(distinct tx_hash) as tx ,

count(distinct TOKENID) as NFT_minted ,

sum(MINT_PRICE_ETH) as ETH ,

SUM(MINT_PRICE_USD) AS USD ,

SUM(TX_FEE) AS FEE

FROM MINT GROUP BY 1)

SELECT

case

when ETH< 0.1 then 'Less Than 0.1 ETH'

when ETH >= 0.1 and ETH < 0.2 then ' 0.1 - 0.2 ETH'

when ETH >= 0.2 and ETH < 0.5 then ' 0.2 - 0.5 ETH'

when ETH >= 0.5 and ETH < 1 then ' 0.5 - 1 ETH'

when ETH >= 1 and ETH < 2 then ' 1 - 2 ETH'

when ETH >= 2 and ETH < 5 then ' 2 - 5 ETH'

else 'More Than 5 ETH' end as "name",

COUNT(DISTINCT NFT_TO_ADDRESS) AS "value"

FROM DETAIL GROUP BY 1