date_trunc('month', block_timestamp) as day,

PLATFORM_NAME as "Platforms",

count(distinct tx_hash) as "Total Number of Sales",

sum(price_usd) as "Total Volume of NFT Sales"

from ethereum.core.ez_nft_sales

where block_Timestamp::date >= '2022-01-01' and block_timestamp::date <= '2022-12-30'

group by 1, 2

ORDER by 1