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