SELECT

voter,

count(*) AS num_votes

FROM ethereum.maker.ez_governance_votes v

WHERE tx_status ='SUCCESS'

AND tx_hash !='0xf609ea50ec79eee06d58f1a4a215ab78c91f57da9a614606e1a2267a84f0b0be'

GROUP BY voter

),

bals AS (

SELECT

voter,

num_votes,

current_bal as mkr_locked

FROM polls v

LEFT OUTER JOIN ethereum.core.ez_current_balances d

ON v.voter = d.user_address

WHERE contract_address = '0xa618e54de493ec29432ebd2ca7f14efbf6ac17f7'

),

voted AS (

SELECT

sum(mkr_locked) AS vt

FROM bals

WHERE num_votes = 1

),

last_30 AS (

SELECT

sum(mkr_locked) as l30

FROM bals

WHERE num_votes <= 25

AND num_votes > 2

),

last_90 AS (

SELECT

sum(mkr_locked) AS l90

FROM bals