DISTINCT SELLER_ADDRESS as wallets,

count(DISTINCT TX_HASH) as sale

from ethereum.core.ez_nft_sales

where nft_address =lower('0xdCB8d9a2A65a006FafEec5695e288B711762D3e4')

GROUP by 1)

SELECT case when sale < 2 then '1 Sales'

when sale BETWEEN 2 and 5 then '2~5 Sales'

when sale BETWEEN 10 and 20 then '10~20 Sales'

when sale BETWEEN 20 and 50 then '20~50 Sales'

when sale BETWEEN 50 and 100 then '50~100 Sales'

else 'More than 100 Sales'

end as stats , count(distinct wallets ) as sellers

from mints

group by 1