min(date_trunc('day', block_timestamp)) first1,

sender as person1

from osmosis.core.fact_transfers

group by 2

)

, tab2 as (

SELECT

min(date_trunc('day', block_timestamp)) as second1,

voter as person2

FROM osmosis.core.fact_governance_votes

WHERE not vote_weight is NULL

GROUP BY 2 )

select

avg(dateDiff('day', first1 , second1 ))

from tab1 left outer join tab2 on person1 = person2

where first1 < second1