select seller_address,

case when NFT_ADDRESS=lower('0x49c36AFa15C7Fdbd57cE3D61D80F39b6615A76Ef') then '3D Invisible Friends'

end as nft,

count (distinct tx_hash) as total_sales,

count (distinct tokenid) as total_token,

sum (price_usd) as total_usd_vol

from ethereum.core.ez_nft_SELLER_ADDRESS

where NFT_ADDRESS=lower('0x49c36AFa15C7Fdbd57cE3D61D80F39b6615A76Ef')

and price_usd > 0

group by nft,total_sales)

select nft,

case when total_usd_vol < 100 then 'Less Than $100'

when total_usd_vol >= 100 and total_usd_vol < 500 then '$100 - $500'

when total_usd_vol >= 500 and total_usd_vol < 1000 then '$500 - $1000'

when total_usd_vol >= 1000 and total_usd_vol < 2500 then '$1000 - $2500'

when total_usd_vol >= 2500 and total_usd_vol < 5000 then '$2500 - $5000'

when total_usd_vol >= 5000 and total_usd_vol < 10000 then '$5000 -$10000'

when total_usd_vol >= 10000 and total_usd_vol < 50000 then '$10000 -$50000'

when total_usd_vol >= 50000 and total_usd_vol < 100000 then '$50000 -$100000'

else 'More Than $100000' end as type,

count (distinct seller_address) as total_seller

from maintable

group by nft,type

order by total_seller desc