select device_id,gender,age,university,gpa
from user_profile
where
(gpa > 3.5 AND university = '山东大学')
or
(gpa > 3.8 AND university = '复旦大学');
//and 优先级 大于 or
//加括号更鲜明 括号优先级最高
select device_id,gender,age,university,gpa
from user_profile
where
(gpa > 3.5 AND university = '山东大学')
or
(gpa > 3.8 AND university = '复旦大学');
//and 优先级 大于 or
//加括号更鲜明 括号优先级最高