when sales_amount >= 0.1 and sales_amount < 1 then '0.1 - 1 SOL'

when sales_amount >= 1 and sales_amount < 10 then '1 - 10 SOL'

when sales_amount >= 10 and sales_amount < 25 then '10 - 25 SOL'

when sales_amount >= 25 and sales_amount < 50 then '25 - 50 SOL'

else 'More Than 50 SOL' end as type,

count (distinct tx_id) as TX_Count

from solana.core.fact_nft_sales

where succeeded = 'TRUE'

and marketplace = 'exchange art'

group by 1

order by 2 desc