题解 | 支付间隔平均值

with t1 as 
(
    select 
    order_log.order_id,
    order_log.time as or_time,
    select_log.time as sel_time,
    abs(timestampdiff(second,order_log.time,select_log.time)) as time_diff
    from
    select_log  left join order_log  on  order_log.order_id = select_log.order_id
    where 
    select_log.time is not null and order_log.time is not null
)
SELECT 
    CAST(AVG(COALESCE(time_diff, 0)) AS SIGNED) AS gap
FROM t1;