CARLJOSEPHLEE

分类

题解(26)

/ 注册

全部文章（共216篇）

题解 | 操作符混合运用

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 30

题解 | Where in 和Not in

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

2025-07-18

1 32

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

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

2025-07-18

1 32

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

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

2025-07-18

1 32

题解 | 用where过滤空值练习

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

2025-07-18

1 37

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

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

2025-07-18

1 41

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

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

2025-07-18

1 34

题解 | 查找年龄大于24岁的用户信息

select device_id,gender,age,university from user_profile where age > 24

2025-07-18

1 34

题解 | 查找学校是北大的学生信息

select device_id,university from user_profile where university = "北京大学"

2025-07-18

1 32

题解 | 将查询后的列重新命名

select device_id user_infos_example from user_profile limit 2

2025-07-18

1 34