加油呀加油加油呀

分类

/ 注册

全部文章（共25篇）

题解 | 评估不同供应商提供的零部件质量和成本情况

with t1 as ( select supplier_id ,component_id ,quality_score ,cost from supply_quality_cost where quality...

2025-07-22

0 29

题解 | 物流公司想要分析快递小哥的收入情况

with t1 as ( select courier_id, sum(delivery_fee) total_delivery_fee from deliveries_info ...

2025-07-22

0 29

题解 | 分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况

with t1 as ( select project_id ,round(avg(performance_score),2) avg_performance_score from employee_projects group by 1 ) select e.emp...

2025-07-21

0 27

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

select destination_city ,transport_name ,round(avg(timestampdiff(day, order_date, delivery_date)),2) average_transport_duration ,sum(t...

2025-07-21

0 27

题解 | 评估2023年不同品牌商品的销售趋势和客户满意度

select brand_id ,sum(sales_amount) total_sales_amount ,sum(sales_quantity) total_sales_quantity ,round(avg(satisfaction_score), 2) avg...

2025-07-21

0 48