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