题解 | 支付间隔平均值
支付间隔平均值
https://www.nowcoder.com/practice/847431ad931e45348eb1ab5657144c28
select cast(avg(abs(TIMESTAMPDIFF(SECOND, o.time, s.time))) as signed) as gap from order_log as o inner join select_log as s on o.order_id = s.order_id
注意:思路不难,下面三点要记住:
查看15道真题和解析
