ranking as (

select

count(distinct TX_HASH ) as TRANSACTIONs ,

SELLER_ADDRESS

FROM optimism.core.ez_nft_sales

WHERE platform_name = 'quixotic' and

EVENT_TYPE = 'sale' and

CURRENCY_SYMBOL = 'ETH' and

ORIGIN_FUNCTION_SIGNATURE='0x912d97fc'

and CURRENCY_ADDRESS='ETH' group by 2

select case

when TRANSACTIONs between 1 and 5 then '1-5 transactions '

when TRANSACTIONs between 5 and 10 then '5-10 transactions '

when TRANSACTIONs between 10 and 15 then '10-15 transactions '

when TRANSACTIONs between 15 and 20 then '15-20 transactions '

when TRANSACTIONs between 20 and 50 then '20-50 transactions '

when TRANSACTIONs between 50 and 100 then '50-100 transactions '

when TRANSACTIONs>100 then 'more than 100 transactions ' end as ee ,

count(distinct SELLER_ADDRESS) as SELLER_ADDRESSs

from ranking

group by 1