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' ;
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' ;