题解 | 支付间隔平均值

支付间隔平均值

https://www.nowcoder.com/practice/847431ad931e45348eb1ab5657144c28

WITH t1 AS (
   SELECT
   o.order_id,
   abs(TIMESTAMPDIFF(second,o.logtime,s.logtime)) as difference
   FROM order_log o JOIN select_log s USING(order_id)
)

SELECT
CAST(avg(difference) as signed) as gap
FROM t1

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务