题解 | 支付间隔平均值
select CAST( avg(abs(timestampdiff (second, o.logtime, s.logtime))) AS SIGNED ) as gap from order_log o, select_log s where o.order_id = s.order_id
select CAST( avg(abs(timestampdiff (second, o.logtime, s.logtime))) AS SIGNED ) as gap from order_log o, select_log s where o.order_id = s.order_id
相关推荐