题目:现在运营想要找到每个学校gpa最低的同学来做调研,请你取出每个学校的最低gpa。
select device_id,u2.university,u2.gpa from (select university, min(gpa) as gpa from user_profile group by university) u2 left join user_profile u on u2.university=u.university and u.gpa=u2.gpa order by u2.university;