CARLJOSEPHLEE

分类

题解(26)

/ 注册

全部文章（共209篇）

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

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

2025-07-18

0 23

题解 | 查找GPA最高值

select round(max(gpa),1) gpa from user_profile where university = "复旦大学"

2025-07-18

1 21

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

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

2025-07-18

1 23

题解 | 操作符混合运用

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

2025-07-18

1 19

题解 | Where in 和Not in

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

2025-07-18

1 19

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

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

2025-07-18

1 20

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

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

2025-07-18

1 19

题解 | 用where过滤空值练习

select device_id,gender,age,university from user_profile where age is not null

2025-07-18

1 19

题解 | 查找除复旦大学的用户信息

select device_id,gender,age,university from user_profile where university != "复旦大学"

2025-07-18

1 25

题解 | 查找某个年龄段的用户信息

select device_id,gender,age from user_profile where 20<=age and age<=23

2025-07-18

1 22