select
project_name,
sum(price) as Sales_Volume_ETH
from optimism.core.ez_nft_sales left outer join optimism.core.dim_labels
on nft_address = address
where price is not null
and project_name is not null
and block_timestamp between '2022-07-01' and '2022-08-01'
group by 1
order by 2 DESC
limit 10