题解 | #操作符混合运用#

select device_id,gender,age,university,gpa from user_profile
where gpa>3.5 and university = '山东大学' 
or gpa>3.8 and university = '复旦大学'
# 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='复旦大学')

1.or的优先级比and高

2.子查询方法