Case

when price_usd between 0 and 25 then 'Between 0 and 25 USD'

when price_usd between 25 and 100 then 'Between 25 and 100 USD'

when price_usd between 100 and 200 then 'Between 100 and 200 USD'

Else 'Greater Than 200 USD'

END as NFT_Price_Distribution,

count(*)

from optimism.core.ez_nft_sales left outer join optimism.core.dim_labels

on address = nft_address

where price_usd is not null

and project_name is not null

group by 1