select device_id,university,gpa from (select device_id,university,gpa,row_number() over(partition by university order by gpa) rk from user_profile) a where rk=1