select device_id,university from user_profile where university like '%北京%';