题解 | #操作符混合运用#
操作符混合运用
http://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
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='复旦大学')
复杂的写法，子查询的方式
