select device_id, university, gpa from (select *, rank() over (partition by university order by gpa) as ranking from user_profile) as rank_table where ranking = 1