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

select
    device_id,
    gender,
    age,
    university,
    gpa
from
    user_profile
where
   (university,gpa)
     in (
        select
            university,gpa
            
        from
            user_profile
        where
            gpa > 3.5
            and university = '山东大学'
    )
    or (university,gpa) in (
        select
            university,gpa
           
        from
            user_profile
        where
            gpa > 3.8
            and university = '复旦大学'
    )