题解 | 操作符混合运用
操作符混合运用
https://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
select device_id,gender,age,university,gpa
from user_profile
where (gpa>3.5 and university="山东大学")
or(gpa>3.8 and university="复旦大学")
order by device_id;
操作符混合运用
https://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
select device_id,gender,age,university,gpa
from user_profile
where (gpa>3.5 and university="山东大学")
or(gpa>3.8 and university="复旦大学")
order by device_id;
相关推荐