在刷代码的小师弟

分类

/ 注册

全部文章（共51篇）

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

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

2023-10-21

1 205

题解 | #查找GPA最高值#

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

2023-10-21

1 212

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

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

2023-10-21

1 231

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

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

2023-10-21

1 289

题解 | #Where in 和Not in#

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

2023-10-21

3 354

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

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

2023-10-21

1 254

题解 | #查找后降序排列#

select device_id,gpa,age from user_profile order by gpa desc,age desc;

2023-10-21

1 293

题解 | #查找后多列排序#

select device_id,gpa,age from user_profile order by gpa,age;

2023-10-21

1 234

题解 | #查找后排序#

select device_id,age from user_profile order by age;

2023-10-21

1 266

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

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

2023-10-18

1 195