SELECT

DISTINCT from_address as fa

FROM flipside_prod_db.mdao_harmony.txs

WHERE block_timestamp > '2022-04-12'

AND block_timestamp < '2022-05-26'

), tab2 as (

SELECT

DISTINCT from_address

FROM flipside_prod_db.mdao_harmony.txs

WHERE block_timestamp > '2022-05-26'

), tab3 as (

SELECT *

FROM tab1

WHERE NOT fa in (SELECT * from tab2)

), tab4 as (

SELECT

DISTINCT tx_hash

FROM flipside_prod_db.mdao_harmony.txs

WHERE block_timestamp > '2022-04-12'

AND block_timestamp < '2022-05-26'

AND from_address in (SELECT * FROM tab3)

), tab10 as (

SELECT

date_trunc('week', block_timestamp),

name,

count(*) as amt

FROM ethereum.core.fact_event_logs

LEFT OUTER JOIN ethereum.core.dim_contracts

ON address = contract_address

WHERE origin_from_address IN (SELECT * FROM tab3)

AND not name is NULL

GROUP BY 1,2