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