题解 | 统计快递运输时长

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