attributes:wasm:"proposal_id" as prop_id,

sum(attributes:wasm:"voting_power") / pow(10, 6) as vote_for_amount

from terra.core.ez_messages

where date(block_timestamp) > '2022-02-01'

and attributes:execute:"_contract_address" = 'terra1k9j8rcyk87v5jvfla2m9wp200azegjz0eshl7n2pwv852a7ssceqsnn7pq'

and attributes:wasm:"proposal_id" = '25'

and attributes:wasm:"vote" = 'for'

and attributes:message:"sender" IN ('terra1jjq6vyq5am5q7tzchc9252y0aczvjtj5ju5hu2', 'terra1h5cankw4vjf2q5cuepxww4cmefww0ds0qqgem7', 'terra1t2fj6czytujh22dwe8zx4sduqkrcpda758mn0q', 'terra1l750ue570u3xwm8008ncs5cw22pwrsz0yawztp', 'terra1q4pxqn3ytlt4wqkdpkt76mx6v4v8h2zakye4jn', 'terra1gn53cj0v8kvwxqg867e3mu9f3q9yzskmfgnvla', 'terra17j6tjl2zxd0lugwz3vvsvjcl0z34kh9hqaa63l', 'terra1630fz3hu9np4fwdqt42eduu69hdzv8yfd3mcdp', 'terra1lv845g7szf9m3082qn3eehv9ewkjjr2kdyz0t6', 'terra1a7rqwyn3zgymqjwhde27d3208muhy8zvgyng6l', 'terra1jy3vlu9x2fc2slundxz0kvj7n5y9hjlj6h0hkw', 'terra1cgdmn0n2x4jj4awnwehstfsy42stcrfqvxcf66', 'terra1pq02fnrm68x6kcv2lhgvyetjelps550w3pq6m2', 'terra1kkwklh7kyr20ktq29uctagkxc7rc27ymp2gf3h', 'terra14rg786jljcyt08mpfjqfe0tyqtkc5ku07u5cpl', 'terra1svlx2775tg2dlfwkpcvu49q4y4xgefp3ftyk0z', 'terra1zaqeperrwghqlsa9yykzsjaets54mtq0u6kl60', 'terra10yfjdgrj40yckeh5gju86fzyyrw46va48ajxg4', 'terra1frrme65c3rxngyry6j44ahwusha6mkkxefu0tr', 'terra19xmydpl3zdnw2ef2mnresrsurn3g23e07a8xya', 'terra1nj7umezl9xdqrsd5n0hzcct0kwadkuc726xpdt', 'terra1nupt9dl6sqhc6eve8dwqsrww2panvju4wxrulp', 'terra1kyndl58gmxnz859j9wm5k85lwzqyhc9jqw3fk6', 'terra1qyxz6nl2pqq8agnmtjdkp3xa90fdt53nndf4en', 'terra18yct96pxtanxkym52mnw3lcems909pdlvuedhd', 'terra1ltryq9mrvk0esdhsrs7dgcehcv0uw5chd2smgn')

group by prop_id

),

table2 as (select

attributes:wasm:"proposal_id" as prop_id,

sum(attributes:wasm:"voting_power") / pow(10, 6) as vote_against_amount

from terra.core.ez_messages

where date(block_timestamp) > '2022-02-01'

and attributes:execute:"_contract_address" = 'terra1k9j8rcyk87v5jvfla2m9wp200azegjz0eshl7n2pwv852a7ssceqsnn7pq'

and attributes:wasm:"proposal_id" = '25'

and attributes:wasm:"vote" = 'against'

and attributes:message:"sender" IN ('terra1jjq6vyq5am5q7tzchc9252y0aczvjtj5ju5hu2', 'terra1h5cankw4vjf2q5cuepxww4cmefww0ds0qqgem7', 'terra1t2fj6czytujh22dwe8zx4sduqkrcpda758mn0q', 'terra1l750ue570u3xwm8008ncs5cw22pwrsz0yawztp', 'terra1q4pxqn3ytlt4wqkdpkt76mx6v4v8h2zakye4jn', 'terra1gn53cj0v8kvwxqg867e3mu9f3q9yzskmfgnvla', 'terra17j6tjl2zxd0lugwz3vvsvjcl0z34kh9hqaa63l', 'terra1630fz3hu9np4fwdqt42eduu69hdzv8yfd3mcdp', 'terra1lv845g7szf9m3082qn3eehv9ewkjjr2kdyz0t6', 'terra1a7rqwyn3zgymqjwhde27d3208muhy8zvgyng6l', 'terra1jy3vlu9x2fc2slundxz0kvj7n5y9hjlj6h0hkw', 'terra1cgdmn0n2x4jj4awnwehstfsy42stcrfqvxcf66', 'terra1pq02fnrm68x6kcv2lhgvyetjelps550w3pq6m2', 'terra1kkwklh7kyr20ktq29uctagkxc7rc27ymp2gf3h', 'terra14rg786jljcyt08mpfjqfe0tyqtkc5ku07u5cpl', 'terra1svlx2775tg2dlfwkpcvu49q4y4xgefp3ftyk0z', 'terra1zaqeperrwghqlsa9yykzsjaets54mtq0u6kl60', 'terra10yfjdgrj40yckeh5gju86fzyyrw46va48ajxg4', 'terra1frrme65c3rxngyry6j44ahwusha6mkkxefu0tr', 'terra19xmydpl3zdnw2ef2mnresrsurn3g23e07a8xya', 'terra1nj7umezl9xdqrsd5n0hzcct0kwadkuc726xpdt', 'terra1nupt9dl6sqhc6eve8dwqsrww2panvju4wxrulp', 'terra1kyndl58gmxnz859j9wm5k85lwzqyhc9jqw3fk6', 'terra1qyxz6nl2pqq8agnmtjdkp3xa90fdt53nndf4en', 'terra18yct96pxtanxkym52mnw3lcems909pdlvuedhd', 'terra1ltryq9mrvk0esdhsrs7dgcehcv0uw5chd2smgn')

group by prop_id

select *

from table1

left outer join table2 on table1.prop_id = table2.prop_id