lizhenzhen

分类

/ 注册

全部文章（共65篇）

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

select destination_city, transport_name, round(avg(datediff(delivery_date,order_date)),2) as average_transport_duration, round(sum(to...

2025-12-15

0 21

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

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

2025-12-15

0 19

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

select p.product_id, p.product_name, total_quantity, average_rating from products_underline p join (select product_id,sum(quanti...

2025-12-15

0 36

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

select p.product_id, p.product_name, round(p.price*s.sum_quantity,2) as total_sales from products_underline p join (select ...

2025-12-15

0 31

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

select industry, sum(sale_amount) as total_sales_amount from merchants_underline m join sales_underline s on m.merchant_id=s.merchant_id grou...

2025-12-15

0 28

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

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

2025-12-15

0 30

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

select c.courier_id, c.courier_name, base_salary+sum_delivery_fee-sum_expense_amount as total_income from couriers_info c join (sele...

2025-12-15

0 23

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

select b.brand_id, b.brand_name, round(sum(return_status)/count(s.order_id),2) as return_rate_July_2024, round(avg(customer_satisfact...

2025-12-15

0 28

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

with t as (select e.employee_id, e.employee_name, pe.performance_score as first_half_2024_score, e.department, pr.project_id, ...

2025-12-15

0 19

题解 | 电商平台想要了解不同商品在不同月份的销售趋势

with t1 as (select s.product_id, product_name, sale_month, sum(quantity) as sum_sales from sales_underline s join products_underlin...

2025-12-08

0 19