题解 | 统计快递运输时长
统计快递运输时长
https://www.nowcoder.com/practice/bb4196936f15424dbabe76a501186d91
SELECT
et.exp_type,
ROUND(AVG(TIMESTAMPDIFF(MINUTE, out_time, in_time)/60),1) time
FROM express_tb et
JOIN exp_action_tb eat ON et.exp_number = eat.exp_number
GROUP BY et.exp_type
ORDER BY time
查看7道真题和解析
