题解 | 支付间隔平均值
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
相关推荐