题解 | 支付间隔平均值
支付间隔平均值
https://www.nowcoder.com/practice/847431ad931e45348eb1ab5657144c28
SELECT
cast(avg(abs(# 根据题目意思，先abs后avg
timestampdiff(second,
order_log.logtime,
select_log.logtime)
)) AS signed) AS gap #需要使用cast函数将timestamp映射成整数值
FROM order_log
LEFT JOIN select_log
ON order_log.order_id=select_log.order_id;
查看12道真题和解析
拼多多集团-PDD公司福利 780人发布