MDao Quiz Week 2

LeewayMDao Quiz Week 2

Updated 2023-01-18

-- Q9: How many transactions took place on Ethereum in October 2022?

-- SELECT COUNT((tx_hash))

-- FROM ethereum.core.fact_transactions

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

-- Q10: How many wallets were active on Ethereum in October 2022?

-- SELECT COUNT(DISTINCT(from_address)) as active_addresses

-- FROM ethereum.core.fact_transactions

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

-- Q11: How many NFT sales took place on Opensea in October 2022?

-- SELECT COUNT(buyer_address) as nftsales_on_opensea

-- FROM ethereum.core.ez_nft_sales

-- WHERE (platform_name = 'opensea'

-- AND event_type = 'sale'

-- AND block_timestamp::DATE BETWEEN '2022-10-01' AND '2022-10-31')

-- Q12: How many swap transactions took place on Uniswap-v2 in October 2022?

-- SELECT COUNT((tx_hash))

-- FROM ethereum.core.ez_dex_swaps

-- WHERE(event_name = 'Swap'

-- AND platform = 'uniswap-v2'

-- AND block_timestamp::DATE BETWEEN '2022-10-01' AND '2022-10-31')

-- Q13: How many unique addresses does the "DIM_LABELS" table on Flipside contain?

-- SELECT COUNT(DISTINCT(address)) as unique_addresses

-- FROM ethereum.core.dim_labels

-- WHERE (

-- blockchain = 'ethereum' AND creator = 'flipside'

-- )

Run a query to Download Data