牛客808484225号

分类

/ 注册

全部文章（共108篇）

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

SELECT a. university, c. difficult_level, count(b. question_id)/count(distinct a. device_id) avg_answer_cnt from user_prof...

Mysql

2022-09-14

0 203

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

select u.university, count(u.university)/count(DISTINCT u.device_id)as answer from user_profile as u inner join question_practice_detail as q on u.dev...

Mysql

2022-09-14

0 238

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

SELECT user_profile.device_id, question_practice_detail.question_id, question_practice_detail.result from user_profile inner join...

Mysql

2022-09-14

0 209

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

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

Mysql

2022-09-13

0 0

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

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_...

Mysql

2022-09-13

0 191

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

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_pr...

Mysql

2022-09-13

0 173

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

select count(1),avg(gpa) from user_profile group by gender having gender='male'

Mysql

2022-09-13

0 203

题解 | #查找GPA最高值#

select gpa from user_profile where university = '复旦大学' order by gpa desc limit 0,1

Mysql

2022-09-13

1 231

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

select user_profile.device_id,user_profile.gender,user_profile.age,user_profile.university,user_profile.gpa from user_profile where (user_profile.gpa&...

Mysql

2022-09-13

0 208

题解 | #Where in 和Not in#

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

Mysql

2022-09-13

0 193