select
case
when sales_amount < 10 then 'Less than 10 SOL'
when sales_amount >= 10 then 'greater than 10 SOL'
end as amount_range ,
count (tx_id) as transactions
from solana.fact_nft_sales
where succeeded = true
group by 1 having amount_range is not NULL