select sum(price) as sm , nft_address , 1 ,
case
when sm <= 0.01 then '<= 0.01'
when sm > 0.01 and sm <= 0.1 then ' > 0.01 and <= 0.1'
when sm > 0.1 and sm <= 1 then ' > 0.1 and <= 1'
when sm > 1 and sm <= 10 then ' > 1 and <= 10'
when sm > 10 then '> 10' end as distribution
from optimism.core.ez_nft_sales
group by 2
order by 1 desc