在考古的长颈鹿很喜欢吃卤蛋

分类

/ 注册

全部文章（共9篇）

题解 | 查询高价值旅行套餐客户的支出与套餐详情

select C. name as customer_name, sum(P.price) as total_travel_cost, count(B.customer_id) as order_count, round(sum(P.price)/count(B.customer_id), ...

2025-07-25

0 30

题解 | 贷款情况

select C.city, sum(A.loan_amount) as total_loan_amount, round(SUM(A.loan_amount)/COUNT(distinct A.customer_id), 2) as average_loan_amount, count(dis...

2025-07-25

0 30

题解 | 连续出现N 次问题【举一反三】

WITH ConsecutiveScores AS ( SELECT 分数, LAG(分数, 1) OVER (ORDER BY 学号) AS prev_score1, LAG(分数, 2) OVER (ORDER BY 学号) AS pre...

2025-07-24

0 29

题解 | 学生成绩排名

SELECT *, ROW_NUMBER() OVER(ORDER BY 成绩 DESC) AS 排名 FROM 成绩表

2025-07-24

0 26

题解 | 查找非空值

SELECT * FROM 教师表 where 教师姓名 is not null

2025-07-24

0 24

题解 | 查找非空值

SELECT 教师号, COALESCE(教师姓名, 0) AS 教师姓名 FROM 教师表

2025-07-24

0 33

题解 | 话题的分布情况

select substring_index(substring_index(subject_set, ',', 2), ',', 1) as subject_id1, count(*) as cnt from comment_detail where substring_index(subst...

2025-07-22

1 26

题解 | 输出提交次数大于2次的用户ID且倒序排列

with t as (select user_id, count(question_id) as cnt from done_questions_record group by user_id having cnt > 2) select user_id from t order b...

2025-07-22

0 42

题解 | 查询被投递过的职位信息

select j.company_id, sum(resume_if_checked) as cnt from deliver_record d join job_info j on j.job_id = d.job_id group by j.company_id having cnt ...

2025-07-22

0 22