题解 | #找出每个学校GPA最低的同学#右连接

select a.device_id, b.university, b.gpa
from user_profile a
right join (
    select university, min(gpa) as gpa
    from user_profile
    group by university
) as b
on a.university = b.university and a.gpa = b.gpa
order by university;