五首绝句哈

分类

/ 注册

全部文章（共38篇）

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

WITH temp AS ( SELECT a.destination_city, b.transport_name, DATEDIFF(a.delivery_date, a.order_date) AS...

2025-06-21

2 44

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

WITH temp AS ( SELECT courier_id, sum(expense_amount) AS expense FROM expenses_info WH...

2025-06-21

1 58

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

WITH temp AS( SELECT a.brand_id,b.brand_name,a.return_status,c.customer_satisfaction_score FROM sales_orders AS a INNER JOIN brand_inf...

2025-06-21

1 63

题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 20%的商品信息

WITH temp AS( SELECT a.product_id,b.product_name,b.category_id,a.sales_amount, round((a.sales_amount - a.cost_amount)/a.sales_amount,2) pr...

2025-06-20

6 48

题解 | 更新员工信息表

WITH temp AS ( SELECT EMPLOYEE_ID, UPDATE_DT, NEW_POSITION FROM ( ...

2025-06-20

0 43

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

WITH temp AS( SELECT DISTINCT a.product_id, a.product_name, a.category, round(coalesce(sum(b.total_amount) OVER...

2025-06-20

2 50

题解 | 每个顾客最近一次下单的订单信息

SELECT order_id, customer_name, order_date FROM ( SELECT a.order_id, b.customer_name, a.or...

2025-06-20

2 46

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

SELECT a.employee_id, b.employee_name, a.performance_score as first_half_2024_score, ROW_NUMBER() OVER (PARTITION BY c.project_name OR...

2025-06-20

2 50

题解 | 对商品的销售情况进行深度分析

WITH t AS ( SELECT c.category AS product_category, b.age_group, sum(a.quantity * a.price) AS total_sal...

2025-06-19

2 53

题解 | 电商平台需要对商家的销售业绩、退款情况和客户满意度进行综合评估

SELECT a.merchant_id, a.merchant_name, COALESCE(b.total_sales, 0) AS total_sales_amount, COALESCE(c.total_refunds, 0) AS total_refund...

2025-06-19

5 46