select MARKETPLACE,count(distinct seller)as unique_sellers,rank()over(order by unique_sellers)as rank
,case
when SALES_AMOUNT<1 then 'Below 1 $ol'
when SALES_AMOUNT>=1 and SALES_AMOUNT<5 then '1~5 $ol'
when SALES_AMOUNT>=5 and SALES_AMOUNT<10 then '5~10 $ol'
when SALES_AMOUNT>=10 and SALES_AMOUNT<15 then '10~15 $ol'
when SALES_AMOUNT>=15 and SALES_AMOUNT<20 then '15~20 $ol'
when SALES_AMOUNT>=20 then 'Above 20 $ol' end as dis_sol
from solana.core.fact_nft_sales
where (MARKETPLACE='coral cube' or MARKETPLACE='hyperspace')
and SUCCEEDED='TRUE'
group by 1,4