,case

when avg(price) between 0 and 0.01 then ' 0 - 0.01 ETH'

when avg(price) between 0.01 and 0.1 then ' 0.01 - 0.1 ETH'

when avg(price) between 0.1 and 1 then ' 0.1 - 1 ETH'

when avg(price) between 1 and 10 then ' 1 - 10 ETH'

when avg(price) >10 then '10+ ETH'

else 'other'

end as bracket

from optimism.core.ez_nft_sales nft

left join optimism.core.dim_labels labels

on nft.nft_address=labels.address

where nft.block_timestamp > current_date - interval ' {{number_of_months}} months'

and nft.NFT_ADDRESS is not null

-- group by nft_address

-- having min(block_timestamp) > CURRENT_DATE - interval ' {{number_of_months}} months'

-- )

group by project_name,nft.nft_address

having sum(price) > 0

order by count(tx_hash) desc

limit 5