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

1.分别查看：union(默认去重)
2.不去重：union all