count(voter) as voters,

count( distinct tx_hash) as votes

from ethereum.maker.ez_governance_votes

group by proposal_id

order by votes desc

limit 10)

select date_trunc('week',block_timestamp) as date,proposal_id,count(tx_hash) as votes

from ethereum.maker.ez_governance_votes

where proposal_id in (select proposal_id from tab1)

and block_timestamp >= '2022-01-01'

group by date,proposal_id

order by date asc