跪求要一个offer

题解

/ 注册

全部文章 / 题解（共27篇）

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

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

2021-11-01

0 307

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

select gender,university,count(id) as user_num, AVG(active_days_within_30) as avg_activate_day, avg(question_cnt) as avg_question_cnt from user_profil...

Mysql

2021-11-01

0 343

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

SELECT COUNT(gender) as male_num,AVG(gpa) as avg_gpa from user_profile where gender="male";

Mysql

2021-11-01

0 248

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

select device_id,gender,age,university,gpa from user_profile where gpa>3.5 and university="山东大学" OR gpa>3.8 and university="复旦大学";

Mysql

2021-11-01

0 258

题解 | #Where in 和Not in#

SELECT device_id,gender,age,university,gpa from user_profile where university in (SELECT university from user_profile where university="北京大学" or univ...

Mysql

2021-11-01

1 731

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

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

Mysql

2021-11-01

0 391

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

SELECT device_id,gender,age,university,gpa from user_profile where gender="male" and gpa>3.5;

Mysql

2021-11-01

0 482