select device_id, gender, age, gpa from user_profile where university = '山东大学' union all select device_id, gender, age, gpa from user_profile where gender = 'male'; 思路:先遍历,提取出山东大学;再遍历,提取性别为maleunion为去重,union all为不去重,……or……是去重的。