什么叫手工排序啊~
with vt as(
select university u,min(gpa) m
from user_profile
group by university
)
SELECT device_id,university,gpa
from user_profile u
join vt
on vt.m=u.gpa and vt.u=u.university
order by case university when '北京大学'then 1
when'北京航空航天大学'then 2
when'北京理工大学'then 3
when'北京师范大学'then 4
when'南京大学'then 5
when'复旦大学'then 6
when '山东大学' then 7
when '浙江大学' then 8
when '清华大学' then 9 end