题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
select up.device_id,up.university,up.gpa from user_profile up join (select university,min(gpa) as gpa from user_profile group by university) a on a.university = up.university and a.gpa = up.gpa order by up.university
查看15道真题和解析
