stf666

分类

/ 注册

全部文章（共55篇）

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

select s2.store_id ,store_name ,product_category ,inventory_quantity ,sales_amount from stores s1 /*用using简化代码，区别是using只会列出一列，on会列出两列*/ /*join sales_i...

2025-10-30

0 30

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

select distinct c.courier_id ,courier_name ,base_salary + total_delivery_fee as total_income from couriers_info c join ( select courier_id ,su...

2025-10-30

0 19

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

with details as ( select e.employee_id, department_name, performance_score, avg(performanc...

2025-10-30

0 26

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

select distinct destination_city ,transport_name ,round(avg(datediff(delivery_date,order_date)) over(partition by destination_city,transport_name),2) ...

2025-10-30

0 25

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

select brand_id ,round(sum(coalesce(sales_amount,0)),2) as total_sales_amount ,sum(coalesce(sales_quantity,0)) as total_sales_quantity ,round(avg(sati...

2025-10-30

0 25

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

select distinct p.product_id ,product_name ,total_quantity ,average_rating from products_underline p join ( select product_id ,sum(coalesce(qu...

2025-10-30

0 25

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

select p.product_id ,product_name ,round(sum(price * coalesce(quantity,0)),2) as total_sales from products_underline p join sales_underline s on p.pro...

2025-10-30

0 19

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

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

2025-10-30

0 18

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

select category_id ,sum(coalesce(order_amount,0)) as total_sales ,sum(case when customer_gender = "男" then 1 else 0 end) as male_customers ,...

2025-10-30

0 21

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

select distinct c.courier_id ,courier_name ,(total_base_salary + total_delivery_fee - total_expense_amount) as total_income from ( select courier_...

2025-10-30

0 21