with mingpa as ( select device_id, university, gpa, min(gpa) over (partition by university) as mins from user_profile ) select device_id, university, mins from mingpa where gpa = mins order by university
with mingpa as ( select device_id, university, gpa, min(gpa) over (partition by university) as mins from user_profile ) select device_id, university, mins from mingpa where gpa = mins order by university