-- forked from [12] MDAO 101: SQL COUNT copy @ https://flipsidecrypto.xyz/edit/queries/b9913170-2da6-435e-b336-88cf6d310b1c

-- forked from metricsdao / [12] MDAO 101: SQL COUNT @ https://flipsidecrypto.xyz/metricsdao/q/11-mdao-101-sql-where-not-wUjg-Y

-- MetricsDAO Blockchain Analytics 101

SELECT COUNT(*) AS num_sales

FROM ethereum.core.ez_nft_sales

WHERE date_part('year', transaction_date) = 2022

AND date_part('month', transaction_date) = 10

AND status = 'successful';