题解 | 物流公司想要分析快递小哥的收入情况
物流公司想要分析快递小哥的收入情况
https://www.nowcoder.com/practice/749ba0168f014c639b516258c0ed6c5d
select di.courier_id, ci.courier_name, sum(di.delivery_fee) + ci.base_salary as total_income from deliveries_info di inner join couriers_info ci on ci.courier_id = di.courier_id where date_format(di.delivery_date , '%Y-%m') = '2024-07' group by di.courier_id, ci.courier_name order by di.courier_id asc
加油干
