題解 | #找出每個(gè)學(xué)校GPA最低的同學(xué)#
找出每個(gè)學(xué)校GPA最低的同學(xué)
http://www.fangfengwang8.cn/practice/90778f5ab7d64d35a40dc1095ff79065
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
