题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
select device_id ,u.university ,gpa from user_profile u inner join ( select university,min(gpa) zuixiao from user_profile group by university ) as sub on sub.university = u.university and sub.zuixiao = u.gpa order by u.university;
投递美团等公司10个岗位 >