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" or=union 要去重union all 不去重 学习该知识点