select

raw_metadata[0]:account_address as address,

label

from osmosis.core.dim_labels

where label_type = 'operator'

and label_subtype = 'validator'

),

proposal_362_governance_votes as (

select

block_timestamp,

tx_id,

voter,

vote_option,

vote_weight

from osmosis.core.fact_governance_votes votes

where proposal_id = 362

and tx_status = 'SUCCEEDED'

),

wallet_saize as (

select

address,

balance/pow(10, 6) as "Balance"

from osmosis.core.fact_daily_balances

where address in (select distinct voter from proposal_362_governance_votes)

and currency = 'uosmo'

and date = current_date - 1

case

when "Balance" >= 1000 then 'More than 1000 OSMO Balance'

when "Balance" >= 100 and "Balance" < 1000 then 'Between 100 and 1000 OSMO Balance'

when "Balance" >= 10 and "Balance" < 100 then 'Between 10 and 100 OSMO Balance'

when "Balance" >= 1 and "Balance" < 10 then 'Between 1 and 10 OSMO Balance'