题解 | 查找GPA最高值

-- 方法1,max

select
    max(gpa) gpa
from
    user_profile
where
    university = "复旦大学";
-- 方法二,排序，限制
select
    gpa
from
    user_profile
where
    university = "复旦大学"
order by
    gpa desc
limit
    1;
-- 方法三,round
select
    round(max(gpa),1) gpa
from
    user_profile
where
    university = "复旦大学";

-- 方法四,format
select
    format(max(gpa),1) gpa
from
    user_profile
where
    university = "复旦大学";