什么叫手工排序啊~

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