WITH total_props AS (
SELECT
count(distinct proposal_id) as total_AIPs
FROM ethereum.aave.ez_votes
WHERE block_timestamp :: date >= CURRENT_DATE - 180
),
cnts AS (
SELECT
voter,
count(*) as num_AIPs_voted,
array_agg (DISTINCT proposal_id) AS AIPs_voted
FROM ethereum.aave.ez_votes
WHERE voter = lower('{{voter_address}}')
AND block_timestamp :: date >= CURRENT_DATE - 180
GROUP BY voter
)
SELECT
voter,
num_AIPs_voted,
total_AIPs,
num_AIPs_voted / total_AIPs * 100 AS percent_participated,
AIPs_voted
FROM cnts
JOIN total_props