题解 | 找出每个学校GPA最低的同学
select device_id, university, gpa from user_profile where (university, gpa) in ( select university, min(gpa) from user_profile group by university ) order by university asc
select device_id, university, gpa from user_profile where (university, gpa) in ( select university, min(gpa) from user_profile group by university ) order by university asc
相关推荐