我的名字在哪里

分类

/ 注册

全部文章（共44篇）

题解 | 找出每个学校GPA最低的同学

SELECT device_id, university, gpa FROM( SELECT device_id,university, gpa, RANK() OVER(PARTITION BY university ORDER BY gpa AS...

2026-04-03

0 25

题解 | 查找山东大学或者性别为男生的信息

SELECT device_id, gender, age, gpa FROM user_profile WHERE university = '山东大学' UNION ALL SELECT device_id, gender, age, gpa FROM user_profile WHERE ge...

2026-04-02

0 24

题解 | 统计每个学校各难度的用户平均刷题数

SELECT university, difficult_level, ROUND(COUNT(q.question_id)/COUNT(DISTINCT q.device_id),4) avg_answer_cnt FROM user_profile u JOIN question...

2026-04-02

0 24

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

SELECT usp.device_id, qpd.question_id, qpd.result FROM user_profile usp JOIN question_practice_detail qpd ON usp.device_id = qpd.device_i...

2026-04-02

0 21