CASE

WHEN s.PRICE_USD < 100 THEN '< $100'

WHEN s.PRICE_USD BETWEEN 100 AND 500 THEN '$100 - $500'

WHEN s.PRICE_USD BETWEEN 500 AND 1000 THEN '$500 - $1000'

ELSE '> $1000'

END AS price_range,

COUNT(*) AS sales_count

FROM

ethereum.nft.ez_nft_sales AS s

JOIN

ethereum.nft.ez_nft_transfers AS t ON s.TX_HASH = t.TX_HASH

WHERE

t.PROJECT_NAME = 'Radbro Webring V2'

GROUP BY

price_range

ORDER BY

price_range;