题解 | 支付间隔平均值
支付间隔平均值
https://www.nowcoder.com/practice/847431ad931e45348eb1ab5657144c28
with
t1 as(
select
convert(avg(abs(timestampdiff(second,ol.logtime,sl.logtime))),unsigned)
from
order_log as ol left join select_log as sl using(order_id)
)
select * from t1
