case when date(b.block_timestamp) > CURRENT_DATE - 90 then '90 - 180 Days Ago' else '90 Days Ago' end splitter,

COUNT(DISTINCT b.tx_hash) AS "Votes",

COUNT(DISTINCT b.voter) AS "Voters"

FROM ethereum.aave.ez_votes b

where date(b.block_timestamp) >= CURRENT_DATE - 180

GROUP BY splitter