题解 | SQLW28 支付间隔平均值
WITH t1 AS (
SELECT a.order_id,
ABS(TIMESTAMPDIFF(SECOND ,b.time,a.time)) AS gap
FROM select_log a
INNER JOIN order_log b
ON a.order_id = b.order_id
WHERE a.pay_method IS NOT NULL
)
SELECT CAST(avg(gap) AS SIGNED ) AS gap
FROM t1;
# 这道题的关键在于支付为空不筛选，整数取值记得进行cast转化！
# 如果用floor还是会有小数点位！
三奇智元机器人科技有限公司公司福利 50人发布
查看5道真题和解析