题解 | 支付间隔平均值
SELECT CAST(AVG(ABS(TIMESTAMPDIFF(second, ol.time, sl.time))) AS SIGNED) gap FROM order_log ol JOIN select_log sl ON ol.order_id = sl.order_id
SELECT CAST(AVG(ABS(TIMESTAMPDIFF(second, ol.time, sl.time))) AS SIGNED) gap FROM order_log ol JOIN select_log sl ON ol.order_id = sl.order_id
相关推荐