题解 | 查询出每个运输方式在不同城市的平均运输时长以及总运输费用
查询出每个运输方式在不同城市的平均运输时长以及总运输费用
https://www.nowcoder.com/practice/673bf7b17e7c4962bcde889980eec872
select destination_city, transport_name, round(avg(datediff(delivery_date, order_date)),2) average_transport_duration, round(sum(total_cost),2) total_transport_cost from transport_detail t join order_info o using (transport_id) join cost_data c using (order_id) group by destination_city, transport_name order by destination_city, transport_name
查看13道真题和解析