select date_trunc('year',block_timestamp) as "Date", count(distinct proposal_id) as "Proposal Count", case
when block_timestamp::date<'2023-01-01' and status='Queued' then 'Expired'
when (block_timestamp::date>='2023-01-01' and block_timestamp::date<='2023-01-31') and status='Queued' then 'Executed'
else status
end as "Status"
from ethereum.aave.ez_proposals
group by 1,3
order by 1