牛客808484225号

分类

/ 注册

全部文章（共26篇）

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

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 174

题解 | #计算男生人数以及平均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 232

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

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 194

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

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

Mysql

2022-09-13

0 184