count(DISTINCT tx_hash) as sales_count,

from ethereum.core.ez_nft_sales

where event_type='sale'

and block_timestamp between '2022-09-1' and '2022-09-30'

and project_name is not null

group by project_name

order by 1 DESC

limit 10