数分菜鸟求职ing

分类

/ 注册

全部文章（共75篇）

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

select e.employee_id,department_name,performance_score from employee_projects e join department_info d on e.employee_id = d.employee_id where departm...

2025-12-23

0 34

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

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

2025-12-23

0 31

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

with t1 as ( select sales_id,brand_id,sales_amount,sales_quantity from sales_data where mid(sales_month,1,4) = 2023 ) select brand_id,sum(...

2025-12-22

0 35

题解 | 电商平台需要对商品的销售和评价情况进行综合分析

with t1 as ( select product_id,round(avg(rating),2) average_rating from reviews_underline r group by product_id having average_ratin...

2025-12-22

0 30

题解 | 电商平台想要查询出每个商品在 2024 年上半年（1 月至 6 月）的总销售额

select p.product_id,product_name,sum(price*quantity) total_sales from products_underline p join sales_underline s on p.product_id = s.product_id where...

2025-12-22

0 29

题解 | 电商平台需要对各行业销售情况综合评估

select industry,sum(sale_amount) total_sales_amount from merchants_underline m join sales_underline s on m.merchant_id = s.merchant_id group by indus...

2025-12-22

0 27

题解 | 查询出每个品牌在不同月份的总销售额以及购买该品牌商品的用户的平均年龄

with t1 as ( select order_id,category_id,order_amount,order_date from order_details where order_date between '2024-01-01' and '2024-06-30'...

2025-12-21

0 31

题解 | 物流公司想要分析快递小哥的薪资构成和绩效情况

with t1 as ( select courier_id,sum(delivery_fee) as fees from deliveries_info where left(delivery_date,7)="2024-07" group by...

2025-12-21

0 27

题解 | 查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分

with t1 as ( select order_id,brand_id,order_date,return_status from sales_orders where month(order_date) = 7 ) select b.brand_id,brand_nam...

2025-12-21

0 29

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

select e.employee_id, employee_name, performance_score first_half_2024_score, row_number() over (partition by project_name order by pe...

2025-12-17

0 28