五首绝句哈

分类

/ 注册

全部文章（共30篇）

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

SELECT industry, round(sum(sale_amount), 2) total_sales_amount FROM ( SELECT DISTINCT b.industry, a.sale_a...

2025-06-21

1 6

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

SELECT category_id, round(sum(order_amount), 2) total_sales, sum( CASE WHEN customer_gender = '男' THEN 1 E...

2025-06-21

1 8

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

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

2025-06-21

1 5

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

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

2025-06-21

1 11

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

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 5

题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 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

1 10

题解 | 更新员工信息表

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

2025-06-20

0 10

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

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

2025-06-20

1 11

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

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

2025-06-20

0 5

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

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

1 8