学习生1

分类

/ 注册

全部文章（共175篇）

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

# select # user_profile.university as university, # round(count(question_practice_detail.question_id)/count(user_profile.device_id),4) as avg_...

2024-11-19

0 77

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

select question_practice_detail.device_id as device_id, question_practice_detail.question_id as question_id, question_practice_detail.resu...

2024-11-18

0 62

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

select university, round(avg(question_cnt),4) as avg_question_cnt from user_profile group by university order by avg_question_cnt

2024-11-18

0 48

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

select university, round(avg(question_cnt),3) as avg_question_cnt, round(avg(answer_cnt),3) as avg_answer_cnt from user_profile group by u...

2024-11-18

0 53

题解 | #查找GPA最高值#

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

2024-11-18

0 39

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

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

2024-11-18

0 50

题解 | #操作符混合运用#

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

2024-11-18

0 53

题解 | #Where in 和Not in#

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

2024-11-18

0 40

题解 | #高级操作符练习(2）#

select device_id, gender, age, university, gpa from user_profile where university='北京大学' or gpa>3.7;

2024-11-18

0 57

题解 | #高级操作符练习(1)#

select device_id, gender, age, university, gpa from user_profile where gender = 'male' and gpa > 3.5;

2024-11-18

0 53