select av.*,

day_of_week_name,

date_trunc('week',block_timestamp) as block_week,

case when day_of_week_name in ('Saturday','Sunday') then 'weekend' else 'weekday' end as day_type

from ethereum.aave.ez_votes av

left join ethereum.core.dim_dates

on block_timestamp::date = date_day

where block_timestamp::date > '2022-06-01'

select

block_week,

day_type,

day_of_week_name,

count(*) as votes

from base

group by 1,2,3