with tbl1 as (
select TX_FROM,min(BLOCK_TIMESTAMP) as ftransact
from
osmosis.core.fact_transactions
group by 1)
, tbl2 as (
select PROPOSER,min(BLOCK_TIMESTAMP) as fsubmit
from osmosis.core.fact_governance_submit_proposal
group by 1 )
select avg(fsubmit::date - ftransact::date)
from tbl1
inner join tbl2
on proposer=tx_from