五首绝句哈

分类

/ 注册

全部文章（共33篇）

题解 | 去掉不需要的单词

sed -e '/B/d' -e '/b/d' 用sed删除含B或b的行

2025-06-22

0 4

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

SELECT a.brand_id, ROUND(SUM(a.sales_amount), 2) AS total_sales_amount, SUM(a.sales_quantity) AS total_sales_quantity, ROUN...

2025-06-22

1 5

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

WITH t1 AS( SELECT product_id,sum(quantity) total_quantity FROM sales_underline GROUP BY product_id ), t2 AS( SELECT product_id,ro...

2025-06-22

1 8

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

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 6

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