and的優先級大于or 我這里寫大括號方便區分,表示兩個條件或兩個條件 可以省略括號
?

select device_id,gender,age,university,gpa from user_profile
where (university='山東大學' and gpa>3.5 )
or (university="復旦大學" and gpa>3.8);

等效于

select device_id,gender,age,university,gpa
from user_profile
where university='山東大學' and gpa>3.5 or university='復旦大學' and gpa>3.8