虽然麻烦但是这样子查询效率更高!
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='复旦大学')