when price between 0 and 10 then 'Between 0 and 10 Flow'

when price between 10 and 30 then 'Between 10 and 30 Flow'

when price between 30 and 50 then 'Between 30 and 50 Flow'

when price between 50 and 100 then 'Between 50 and 100 Flow'

when price between 100 and 250 then 'Between 100 and 250 Flow'

when price between 250 and 500 then 'Between 250 and 500 Flow'

else 'Greater than 500 Flow'

end as NFT_Price_Distribution,

count(*)

from flow.core.ez_nft_sales left outer join flow.core.dim_allday_metadata

on flow.core.ez_nft_sales.nft_id = flow.core.dim_allday_metadata.nft_id

where team is not null

group by 1