不想上网课的高级磨洋工练习时长两年半

分类

/ 注册

全部文章（共69篇）

题解 | 浙江大学用户题目回答情况

select A.device_id,B.question_id, B.result from user_profile A left join question_practice_detail B on A.device_id = B.device_id where A.university ...

2025-09-25

0 16

题解 | 分组排序练习题

select university,AVG(question_cnt) as avg_question_cnt from user_profile group by university order by avg_question_cnt ASC

2025-09-25

0 18

题解 | 分组过滤练习题

select university,AVG(question_cnt) as avg_question_cnt,AVG(answer_cnt) as avg_answer_cnt from user_profile group by university having (AVG(question_...

2025-09-25

0 16

题解 | 分组计算练习题

select gender,university,count(id) as user_num,AVG(active_days_within_30) as avg_active_day,AVG(question_cnt) as avg_question_cnt from user_profile g...

2025-09-25

0 26

题解 | 查找GPA最高值

select gpa from user_profile where university = "复旦大学" and gpa = (select max(gpa) from user_profile where university = "复旦大学" )

2025-09-24

0 16

题解 | 查看学校名称中含北京的用户

select device_id,age,university from user_profile where university like "%北京%"

2025-09-24

0 16

题解 | 操作符混合运用

select device_id, gender,age,university,gpa from user_profile where gpa > 3.5 and university = "山东大学" or gpa > 3.8 and university = ...

2025-09-24

0 18

题解 | Where in 和Not in

select device_id,gender,age,university,gpa from user_profile where university IN ("北京大学","复旦大学","山东大学")

2025-09-24

0 17

题解 | #栈的压入、弹出序列#

# # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param pushV int整型一维数组 # @param popV int整型一维数组 # @return bool布尔型 # class Solution: def IsPopOrde...

2024-08-13

0 186

题解 | #【模板】栈#

import sys class ListNode: def __init__(self, val) -> None: self.val = val self.next = None class LinkedList: ...

2024-08-13

0 154