勤奋努力的追梦人想要offer

分类

/ 注册

全部文章（共24篇）

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

SELECT device_id, gender, age, gpa FROM user_profile WHERE university = '山东大学' union all SELECT device_id, gender, age, gpa FROM user_profile WHERE...

2025-05-06

0 10

题解 | 统计每个用户的平均刷题数

select up.university, qd.difficult_level, round(count(qpd.id)/count(distinct up.device_id), 4) as avg_answer_cnt from user_profi...

2025-05-06

0 11

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

SELECT up.university, qd.difficult_level, ROUND(COUNT(qpd.id) / COUNT(DISTINCT up.device_id), 4) AS avg_answer_cnt FROM user_profile u...

2025-05-06

0 11

题解 | 统计每个学校的答过题的用户的平均答题数

SELECT up.university, round(count(qpd.question_id)/count(distinct qpd.device_id),4) as avg_answer_cnt FROM user_profile up JOIN que...

2025-05-06

0 15

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

SELECT qpd.device_id, qpd.question_id, qpd.result FROM question_practice_detail qpd JOIN user_profile up ON qpd.device_id = up.device_id WHERE up....

2025-05-06

0 12

题解 | 分组排序练习题

select university,avg(question_cnt) as avg_question_cnt from user_profile group by university order by avg_question_cnt; select university,avg(questio...

2025-05-06

0 10

题解 | 分组计算练习题

select gender, university, count(device_id) as user_num, avg(active_days_within_30) as avg_active_day, avg(question_cnt) as avg_questi...

2025-05-06

0 12

题解 | 计算男生人数以及平均GPA

select count(gender) as male_num,avg(gpa) as avg_gpa from user_profile where gender='male'; select count(gender) as male_num,avg(gpa) as avg_gpa /COUN...

2025-05-05

0 14

题解 | 查找GPA最高值

select max(gpa) as gpa from user_profile where university='复旦大学'; select max(gpa) as gpa /SELECT MAX(gpa)：使用 MAX 聚合函数，选择 gpa 字段中的最大值，然后改名gpafrom user_...

2025-05-05

0 11

题解 | 查找GPA最高值

select max(gpa) as gpa from user_profile where university='复旦大学';

2025-05-05

0 14