SELECT

block_timestamp,

voter,

proposal_id

FROM osmosis.core.fact_governance_votes

qualify(ROW_NUMBER() over(PARTITION BY voter

ORDER BY

block_timestamp ASC)) = 1

),

first_tx AS (

SELECT

block_timestamp,

tx_from as address

FROM osmosis.core.fact_transactions

QUALIFY(ROW_NUMBER() over (PARTITION BY tx_from

ORDER BY

block_timestamp ASC)) = 1

SELECT

median(datediff(day, f.block_timestamp, v.block_timestamp)) as median_dif,

v.proposal_id

FROM proposal_voters v

LEFT OUTER JOIN first_tx f

ON v.voter = f.address

GROUP BY proposal_id