marketplace,

CASE

WHEN (SALES_AMOUNT) <= 1 THEN 'a.below 1 SOL'

WHEN (SALES_AMOUNT) > 1 and (SALES_AMOUNT) <=5 THEN 'b.1-5 SOL'

WHEN (SALES_AMOUNT) > 5 and (SALES_AMOUNT) <=10 THEN 'c.5-10 SOL'

WHEN (SALES_AMOUNT) > 10 THEN 'd.above 10 SOL'

END as buckets,

count(distinct tx_id) as sale_no,

count(distinct purchaser) as buyer_no

from solana.core.fact_nft_sales

where SUCCEEDED='TRUE'

and marketplace in ('hyperspace','coral cube')

and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}}

group by 1,2 having buckets is not null