#查出每个学校最小的gpa
select
device_id,
university,
gpa
from user_profile u
where gpa=(
select min(gpa)
from user_profile
where university=u.university
)
order by university;
#查出每个学校最小的gpa
select
device_id,
university,
gpa
from user_profile u
where gpa=(
select min(gpa)
from user_profile
where university=u.university
)
order by university;