[12] MDAO 101: SQL COUNT copy copy

jonome[12] MDAO 101: SQL COUNT copy copy

-- 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

-- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101

SELECT COUNT(*) AS successful_sales_count

FROM ethereum.core.ez_nft_sales

WHERE DATE_TRUNC('month', occurred_at) = '2022-10-01

AND transaction_status = 'successful';

Run a query to Download Data