select device_id,university
from user_profile
where university = "北京大学"