dannerCopy of Metrics DAO Segment 1 Quiz
    Updated 2022-08-02
    --Quiz question 6
    -- Select count(TX_HASH) from ethereum.core.fact_transactions where BLOCK_TIMESTAMP BETWEEN '2022-06-01' and '2022-06-30'
    --Select count (distinct TX_HASH) from ethereum.core.fact_transactions where BLOCK_TIMESTAMP > '2022-05-31' and BLOCK_TIMESTAMP < '2022-07-01'A STATUS = 'SUCCESS' limit 100;

    --Quiz question 7
    -- Select Count(distinct FROM_ADDRESS) from ethereum.core.fact_transactions where BLOCK_TIMESTAMP BETWEEN '2022-06-01' and '2022-06-30' limit 100;

    --Quiz question 8
    -- Select COUNT (distinct TX_HASH) from ethereum.core.ez_nft_sales where BLOCK_TIMESTAMP BETWEEN '2022-06-01' and '2022-06-30' and EVENT_TYPE = 'sale' and lower(PLATFORM_NAME) = 'opensea' limit 100;

    --Quiz question 9
    -- Select COUNT(DISTINCT TX_HASH) from ethereum.core.ez_dex_swaps where BLOCK_TIMESTAMP BETWEEN '2022-06-01' and '2022-06-30' AND EVENT_NAME = 'Swap' and PLATFORM = 'uniswap-v2' limit 100;

    --Quiz question 10
    --Select Address_name from ethereum.core.dim_labels where address = '0x0a3f6849f78076aefadf113f5bed87720274ddc0' limit 100;


    Select
    count(distinct tx_hash)
    from ethereum.core.ez_nft_sales
    where block_timestamp >= '2022-06-01 00:00:01'
    and block_timestamp <= '2022-06-01 00:10:00'
    -- BLOCK_TIMESTAMP BETWEEN '2022-06-01'
    -- and '2022-06-30'
    and EVENT_TYPE = 'sale'
    and lower(PLATFORM_NAME) = 'opensea' limit 100;

    Run a query to Download Data