题解 | 操作符混合运用

-- and的优先级大于or 如果不确定可以用()来改变运算的优先级

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 asc;

-- 复杂的方式，子查询

select device_id,gender,age,university,gpa
from user_profile
where 
device_id in (select device_id from user_profile where gpa>3.5 and university="山东大学")
or
device_id in (select device_id from user_profile where gpa>3.8 and university="复旦大学");