题解 | 支付间隔平均值
支付间隔平均值
https://www.nowcoder.com/practice/847431ad931e45348eb1ab5657144c28
SELECT
CAST(
AVG(
ABS(TIMESTAMPDIFF(SECOND,a.time,b.time))
) AS SIGNED
) AS gap
FROM order_log AS a
INNER JOIN select_log AS b
ON (a.order_id = b.order_id)
格力公司福利 386人发布