proposals AS (

SELECT

DATEDIFF(day, MIN(block_timestamp::date), CURRENT_DATE) AS "Days",

ROUND(AVG(end_voting_period - start_voting_period)) AS "Voting Period", -- blocks

COUNT(DISTINCT proposal_id) AS "Proposals",

COUNT(DISTINCT proposer) AS "Proposers"

FROM

ethereum.aave.ez_proposals

),

votes AS (

SELECT

COUNT(DISTINCT tx_hash) AS "Votes",

COUNT(DISTINCT voter) AS "Voters",

ROUND(SUM(voting_power) / POW(10, 18)) AS "Voting Powers", -- Aave

ROUND(AVG(voting_power) / POW(10, 18)) AS "Average Voting Power" -- Aave

FROM

ethereum.aave.ez_votes

)

*

proposals,

votes