select nft_to_address,

count (distinct tx_hash) as TX_Count,

count (distinct tokenid) as Minted_Tokens,

sum (mint_price_usd) as Volume

from ethereum.core.ez_nft_mints

WHERE nft_address =lower('0xdCB8d9a2A65a006FafEec5695e288B711762D3e4')

group by 1)

select case when minted_tokens = 1 then 'Minted 1 NFT'

when minted_tokens = 2 then 'Minted 2 NFTs'

when minted_tokens = 3 then 'Minted 3 NFTs'

when minted_tokens = 4 then 'Minted 4 NFTs'

when minted_tokens = 5 then 'Minted 5 NFTs'

else 'Minted More Than 5 NFTs' end as type,

count (distinct nft_to_address) as nft_count

from maintable

group by 1

order by 2 desc