题解 | 物流公司想要分析快递小哥的收入情况
物流公司想要分析快递小哥的收入情况
https://www.nowcoder.com/practice/749ba0168f014c639b516258c0ed6c5d
select c.courier_id,
courier_name,
base_salary+delivery total_income
from couriers_info c
join (
select courier_id, sum(delivery_fee) delivery
from deliveries_info
where delivery_date between '2024-07-01' and '2024-07-31'
group by courier_id
) d on c.courier_id=d.courier_id
order by c.courier_id
查看6道真题和解析