题解 | 物流公司想要分析快递小哥的收入情况
物流公司想要分析快递小哥的收入情况
https://www.nowcoder.com/practice/749ba0168f014c639b516258c0ed6c5d
select c.courier_id , courier_name , sum(base_salary+delivery_fee ) total_income from couriers_info c left join (select courier_id,sum(delivery_fee) delivery_fee from deliveries_info where month(delivery_date) = 7 group by 1 ) d on c.courier_id = d.courier_id group by 1,2