count(distinct address) as W_Voters_Num

from terra.daily_balances

where balance_usd >1000000

and date = '2022-02-12'

and

(address in (select msg_value:sender as Voter_mir_anc

from terra.msgs

where msg_value:contract in ('terra1wh39swv7nq36pnefnupttm2nr96kz7jjddyt2x'

,'terra1f32xyep306hhcxxxf7mlyh0ucggc00rm2s9da5')

and block_timestamp >= cast('2022-02-12' as date)-90

and msg_value:execute_msg:cast_vote:poll_id is not null

AND tx_status='SUCCEEDED'

group by Voter_mir_anc)

or address in (

select voter as Terra_Voter

from terra.gov_vote

where block_timestamp >= cast ('2022-02-12' as date)-90

AND tx_status='SUCCEEDED'