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