cantin

分类

题解(3)

/ 注册

全部文章（共22篇）

题解 | 分析每个员工在不同项目中的绩效情况

select e.employee_id, employee_name, performance_score as first_half_2024_score, row_number()over( partition by pf.project_id...

2025-09-30

0 28

题解 | 查询出每个运输方式在不同城市的平均运输时长以及总运输费用

select destination_city, transport_name, round(sum(timestampdiff(day,order_date,delivery_date))/count(*),2) as average_transport_duratio...

2025-09-30

0 27