题解 | 物流公司想要分析快递小哥的收入情况
物流公司想要分析快递小哥的收入情况
https://www.nowcoder.com/practice/749ba0168f014c639b516258c0ed6c5d
with t1 as (
select delivery_id,courier_id,delivery_date,delivery_fee
from deliveries_info d
where mid(delivery_date,1,7) = '2024-07'
)
select t1.courier_id,courier_name,sum(delivery_fee)+base_salary total_income
from t1 join couriers_info c on t1.courier_id = c.courier_id
group by t1.courier_id
三奇智元机器人科技有限公司公司福利 83人发布
查看8道真题和解析