SQL Adept Exam - Ethereum Data

In order on the dashboard: 1. Compute these two metrics: sum of transactions per day, and count of distinct addresses that initiated a transaction (i.e. the “from” side). 2. Compute the sum of transactions per day by label type. 3. Compute the USD denominated volume on Ethereum per day. 4. Identify the top 10 addresses per day ranked by transaction count. Note - I set block_timestamp > 2021-06-01 to limit the amount of data we are returning. Looking at all of the ethereum data can obviously be a bit heavy for the query :)