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'

写两段独立的查询语句，中间用 union all 连接即可