五首绝句哈

分类

/ 注册

全部文章（共38篇）

题解 | 异常的邮件概率

SELECT date,round(avg(type = 'no_completed'),3) p FROM( SELECT a.type,a.date FROM email AS a INNER JOIN user AS b ON a.send_id = b.id ...

2025-06-23

1 50

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

WITH temp AS( SELECT c.emp_no,c.manager_no,d.salary emp_salary,e.salary manager_salary FROM( SELECT a.emp_no,b.emp_no manager_n...

2025-06-23

0 39

题解 | 浙大不同难度题目的正确率

WITH temp AS( SELECT a.device_id,b.result,c.difficult_level FROM( SELECT device_id,university FROM user_profile ...

2025-06-23

1 56

题解 | 统计复旦用户8月练题情况

SELECT DISTINCT a.device_id,a.university, coalesce(count(b.result) OVER (PARTITION BY device_id),0) AS question_cnt, coalesce(sum(CASE WHEN b.result =...

2025-06-22

1 49

题解 | 更新用户积分信息？

WITH temp AS( SELECT b.user_id,b.point,COALESCE(a.total_cost,0) AS total_cost FROM( SELECT user_id,sum(order_price) as total_c...

2025-06-22

1 45

题解 | 去掉不需要的单词

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

2025-06-22

1 36

题解 | 评估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

8 52

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

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

3 61

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

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

2025-06-21

1 38

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

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

2025-06-21

1 45