select

LIQUIDITY_PROVIDER,

datediff('day', min(block_timestamp), max(block_timestamp)) as time_between,

count(distinct tx_hash) as LPs

from ethereum.uniswapv3.ez_lp_actions

where block_timestamp > '2022-03-07' -- same date orca whirlpools start

group by 1 )

select

avg(time_between/LPs),

median(time_between/LPs) ,

max(time_between/LPs)

from tab1