select

voter,

voting_power

from ethereum.core.ez_snapshot

where space_id = 'apecoin.eth'

and proposal_id = '0x0fb1d66dc79f164290a485fa2227c6e086dab1a87257db8139a4de4c27892c9c'

select

user_address,

b.voting_power as voting_power_election,

current_bal,

current_bal - b.voting_power as diff

from ethereum.core.ez_current_balances a

left join nominations_table b on a.user_address = b.voter

where contract_address = lower('0x4d224452801ACEd8B2F0aebE155379bb5D594381')

and b.voting_power > 100

order by 2 desc