SELECT
case when date(a.block_timestamp) > CURRENT_DATE - 90 then '90 - 180 Days Ago' else '90 Days Ago' end splitter,
COUNT(DISTINCT a.proposal_id) AS "Proposals",
COUNT(DISTINCT a.proposer) AS "Proposers"
FROM ethereum.aave.ez_proposals a
where date(a.block_timestamp) >= CURRENT_DATE - 180
GROUP BY splitter