select

seller,

count (distinct tx_id) num_transactions,

count(distinct nft_id) num_sales,

sum(price) sales_volume

from flow.core.ez_nft_sales

where nft_collection = 'A.e3ad6030cbaff1c2.DimensionX'

and tx_succeeded = true

group by 1

select

case

when num_transactions = 1 then 'one transaction'

when num_transactions BETWEEN 2 and 5 then'2 - 5 transactions'

when num_transactions BETWEEN 5 and 10 then'5 - 10 transactions'

when num_transactions BETWEEN 10 and 50 then '10 - 50 transactions'

when num_transactions BETWEEN 50 and 100 then '50 - 100 transactions'

else 'greater than 100 transactions'

end transactions ,

count (distinct seller) num_sellers

from NFTs

group by 1