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

#1 and or 最快36ms
#2 union all 37ms
#3 in 45ms
select
    device_id,
    gender,
    age,
    university,
    gpa
from
    user_profile
where id in (
select
    case
        when gpa > 3.5
        and university = '山东大学' then id
        when gpa > 3.8
        and university = '复旦大学' then id
        else -1
    end
from
    user_profile)