select

proposer,

Min(date_trunc('hour', block_timestamp)) as min_date,

Max(date_trunc('hour', block_timestamp)) as max_date,

count(*) as transactions

from flow.core.fact_transactions

group by 1

having Min(date_trunc('hour', block_timestamp)) < current_date - 2

)

select

sum(datediff('hour', min_date, max_date))/ sum(transactions) as Time_Between_Transactions

from tab1