题解 | 操作符混合运用
操作符混合运用
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)
order by device_id;
#使用union关键字
SELECT device_id, gender, age, university, gpa
from user_profile
where university in ('山东大学') and gpa>3.5
union all
select device_id, gender, age, university, gpa
from user_profile
where university in ('复旦大学') and gpa >3.8
order by device_id;
