select u.device_id as device_id,u.university as university, u.gpa as gpa from (select * ,row_number() over (partition by ub.university order by ub.gpa asc) as rn from user_profile ub ) u where u.rn = 1 order by u.university;