[12] MDAO 101: SQL COUNT copy

jonome[12] MDAO 101: SQL COUNT copy

-- 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(DISTINCT status) AS successful_status

FROM ethereum.core.ez_nft_sales

WHERE block_timestamp::DATE BETWEEN '2022-10-01' AND '2022-11-01'

AND platform_name = 'opensea'

AND status = 'successful';

Run a query to Download Data