小燕子my

分类

/ 注册

全部文章（共137篇）

题解 | #小飞机#

# import sys # for line in sys.stdin: # a = line.split() # print(int(a[0]) + int(a[1])) print(" ** ") print(" ** ...

2024-08-16

0 86

题解 | #Hello Nowcoder#

# import sys # for line in sys.stdin: # a = line.split() # print(int(a[0]) + int(a[1])) print("Hello Nowcoder!")

2024-08-16

0 92

题解 | #查找后降序排列#

SELECT device_id,gpa,age FROM user_profile ORDER BY gpa DESC,age DESC

2024-08-16

0 89

题解 | #查找后多列排序#

SELECT device_id,gpa,age FROM user_profile ORDER BY gpa,age

2024-08-16

0 100

题解 | #查找后排序#

SELECT device_id,age FROM user_profile ORDER BY age

2024-08-16

0 90

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

SELECT A.device_id,A.question_id,A.result FROM (SELECT device_id,question_id,result FROM question_practice_detail) A JOIN (SELECT device_id FROM user...

2024-08-16

0 97

题解 | #分组排序练习题#

SELECT A.university,A.avg_question_cnt FROM (SELECT university,AVG(question_cnt)AS avg_question_cnt FROM user_profile GROUP BY university)A ORDER BY...

2024-08-16

0 120

题解 | #分组过滤练习题#

SELECT A.university,A.avg_question_cnt,A.avg_answer_cnt FROM (SELECT university ,AVG(question_cnt) AS avg_question_cnt,AVG(answer_cnt) AS avg_answer_...

2024-08-16

0 93

题解 | #分组过滤练习题#

SELECT A.university,A.avg_question_cnt,A.avg_answer_cnt FROM (SELECT university ,AVG(question_cnt) AS avg_question_cnt,AVG(answer_cnt) AS avg_answer_...

2024-08-16

0 80

题解 | #分组计算练习题#

SELECT gender,university,COUNT(*) AS user_num,AVG(active_days_within_30) AS avg_active_day,AVG(question_cnt) AS avg_question_cnt FROM user_profile GRO...

2024-08-16

0 105