AS (SELECT voter,

block_timestamp,

tx_id,

description

FROM osmosis.core.fact_governance_votes j

JOIN osmosis.core.dim_vote_options k

ON j.vote_option = k.vote_id

WHERE proposal_id IN ( '362' )

AND tx_status = 'SUCCEEDED'),

f

AS (SELECT DISTINCT j.voter,

j.block_timestamp,

j.tx_id,

k.description

FROM osmosis.core.fact_governance_votes j

JOIN osmosis.core.dim_vote_options k

ON j.vote_option = k.vote_id

JOIN g l

ON j.voter = l.voter

AND j.block_timestamp > l.block_timestamp

AND k.description != l.description

WHERE proposal_id IN ( '362' )

AND tx_status = 'SUCCEEDED')

SELECT CASE

WHEN ( balance / Pow(10, decimal) ) < 1 THEN 'Less Than 1'

WHEN ( balance / Pow(10, decimal) ) >= 1

AND ( balance / Pow(10, decimal) ) < 10 THEN 'between 1-10'

WHEN ( balance / Pow(10, decimal) ) >= 10

AND ( balance / Pow(10, decimal) ) < 100 THEN 'between 10 - 100'

WHEN ( balance / Pow(10, decimal) ) >= 100

AND ( balance / Pow(10, decimal) ) < 1000 THEN 'between 100 - 1000'

WHEN ( balance / Pow(10, decimal) ) >= 1000

AND ( balance / Pow(10, decimal) ) < 10000 THEN

'between 1000 - 10000'

ELSE 'More Than 10000'