题解 | #操作符混合运用#
操作符混合运用
http://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
select device_id,gender,age,university,gpa
from user_profile
where (university,gpa) in (select university,gpa from user_profile where university='山东大学' and gpa>3.5)
or (university,gpa) in (select university,gpa from user_profile where university='复旦大学' and gpa>3.8)
