and的優(yōu)先級(jí)大于or 我這里寫(xiě)大括號(hào)方便區(qū)分,表示兩個(gè)條件或兩個(gè)條件 可以省略括號(hào)
?

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

等效于

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