虽然麻烦但是这样子查询效率更高!
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='山东大学' )
&nbs***bsp;
device_id in (select device_id from user_profile where gpa>3.8 and university='复旦大学')