MetricsDAO_Quiz_1_Solution

LeewayMetricsDAO_Quiz_1_Solution

Updated 2023-01-10

-- Question 9

-- SELECT *

-- FROM ethereum.core.fact_transactions

-- WHERE from_address = '0xe2c25d061d632b166f74f04fbdeba838966caea2'

-- ORDER BY blocK_timestamp DESC

-- LIMIT 15

--- Question 10

-- SELECT *

-- FROM ethereum.core.fact_transactions

-- WHERE from_address = '0x05e793ce0c6027323ac150f6d45c2344d28b6019'

-- ORDER BY block_timestamp DESC

-- LIMIT 10

-- Question 11

-- SELECT COUNT(*) as nft_count

-- FROM ethereum.core.ez_nft_mints

-- WHERE block_number = '14666971'

-- AND event_type = 'nft_mint'

-- QUESTION 12

-- SELECT COUNT(DISTINCT(label) as unique_dex

-- FROM ethereum.core.dim_labels

-- WHERE label_type = 'dex'

-- AND creator = 'flipside'

-- Question 13

-- SELECT address_name

-- FROM ethereum.core.dim_labels

-- WHERE address = '0x8484ef722627bf18ca5ae6bcf031c23e6e922b30'

Run a query to Download Data