with cte as (
select graduate_year,round(avg(gpa),2) as avg_gpa
from user_profile
where graduate_year >=2022
group by graduate_year )
select case when graduate_year='2023' then '大三'
when graduate_year='2024' then '大二'
when graduate_year='2025' then '大一'
else '大四' end as grade
,avg_gpa
from cte
order by avg_gpa desc

京公网安备 11010502036488号