lizhenzhen

分类

/ 注册

全部文章（共65篇）

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

select c.name as customer_name, sum(price) as total_travel_cost, count(*) as order_count, round(sum(price)/count(*),2) as avg_order_p...

2025-12-19

0 20

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

select product_line, region, channel_name, sum(sale_amount) as total_sale_amount, count(*) as total_sale_quantity from oppo_produ...

2025-12-19

0 29

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

select product_line, region, channel_name, sum(sale_amount) as total_sale_amount, count(*) as total_sale_quantity from oppo_produ...

2025-12-19

0 20

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

select p.product_id ,product_name ,competitor_name ,total_sales_amount_of_product ,(total_sales_amount_of_product-total_competito...

2025-12-19

0 21

题解 | 哪些产品在特定时间段内表现最为出色

select p.product_id, product_name, total_sales_amount, total_sales_quantity from products p join (select product_id, su...

2025-12-16

0 27

题解 | 了解 2023 年全年所有商品的盈利情况

select p.product_id, sum((unit_price-purchase_price)*quantity) as total_profit, round((avg(unit_price)-purchase_price)/purchase_price*100...

2025-12-16

0 26

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

select s1.supplier_id, supplier_name, component_name, quality_score, cost from supply_quality_cost s1 join components c using(com...

2025-12-16

0 18

题解 | 分析不同门店各类商品的库存情况和销售情况

select sa.store_id, store_name, product_category, inventory_quantity, sales_amount from sales_inventory sa join stores st on st....

2025-12-15

0 22

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

select c.courier_id, courier_name, base_salary+sum_delivery_fee as total_income from couriers_info c join (select courier_id,sum(del...

2025-12-15

0 30

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

-- 部门平均绩效得分 select e.employee_id, department_name, performance_score from employee_projects e join (select employee_id, ...

2025-12-15

0 22