题解 | 支付间隔平均值

SELECT 
    CAST(ROUND(SUM(t.gap) / COUNT(t.gap), 0) AS SIGNED) AS gap
FROM (
    SELECT
        ABS((HOUR(s.logtime)*3600+MINUTE(s.logtime)*60+SECOND(s.logtime)) - (HOUR(o.logtime)*3600 + MINUTE(o.logtime)*60 + SECOND(o.logtime))) AS gap
    FROM order_log o JOIN select_log s
    ON o.order_id = s.order_id) t