select up.device_id,up.gender,up.age,up.gpa from user_profile up where up.university='山东大学'
union all
select up.device_id,up.gender,up.age,up.gpa from user_profile up where gender='male';
//注意union all是不去重的，union是去重的