#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 ...