when SALES_AMOUNT between 10 and 100 then 'above 10 sol'

when SALES_AMOUNT >100 then 'above 100 sol'

else 'less than 10 sol'

end as price,

count (distinct PURCHASER) as unique_purchaser

from solana.fact_nft_sales

group by price

order by 2