SELECT b.device_id, b.university, b.gpa
FROM 
(
SELECT device_id, university, ROW_NUMBER() OVER(PARTITION BY university ORDER BY gpa) rak, gpa
FROM user_profile
) b
WHERE
b.rak = 1
ORDER BY b.university

直接用查询后的表即可