eagle10

分类

/ 注册

全部文章（共39篇）

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

select distinct destination_city,transport_name, round(avg(timestampdiff(day, order_date,delivery_date)) over(partition by destinatio...

2025-08-16

0 29

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

select employee_id, employee_name, performance_score as first_half_2024_score, row_number() over ( partition by p...

2025-08-16

0 28

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

select category_id, sum(order_amount) as total_sales, sum(if(customer_gender = '男', 1, 0)) as male_customers, sum(if(customer_gender =...

2025-08-14

0 27

题解 | 分析各产品线在特定时间段内的销售情况

select product_line,region,channel_name,sum(sale_amount) as total_sale_amount, count(*) as total_sale_quantity from oppo_products left join sales_data...

2025-07-31

0 25

题解 | 深入分析各款产品年总销售额与竞品的年度对比

with t1 as ( select product_id, product_name, sum( quarter_1_sales_amount + quarter_2_...

2025-07-29

0 28

题解 | 查询高价值旅行套餐客户的支出与套餐详情

select customers.name as customer_name, total_travel_cost, order_count, avg_order_price from ( select customer...

2025-07-23

0 32

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

with t1 as( select distinct department_name, avg(performance_score) over ( partition by department_name ) as avg_perf...

2025-07-17

0 39

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

with t1 as ( select distinct courier_id, courier_name, sum(delivery_fee) over ( partit...

2025-07-15

0 28

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

with t1 as (select distinct product_id, avg(rating) over ( partition by product_id ) as average_rating from pr...

2025-07-13

0 36

题解 | 分析每个商品在不同时间段的销售情况

with t1 as ( select distinct product_id, product_name, sum(total_amount) over ( partit...

2025-07-08

0 53