platform_name,

count(distinct tx_hash) as sales

from ethereum.core.ez_nft_sales

where event_type = 'sale'

and date_trunc('month', block_timestamp) = '2022-10-01'

group by platform_name

order by sales