最大平均gpa sql

Question

好了，这就是我需要回答的问题:哪个系/专业的平均GPA最高？

我是SQL的新手，实际上我现在只做了3个星期。我有最高平均分的答案，但我想知道如何让它显示专业和GPA，而不仅仅是gpa。

    select max (avg_gpa)
    from (select major, avg(gpa) AS avg_gpa
    from lab5_student
    group by major);

感谢您对此的任何见解！

拍拍

Answer 1

将主列添加到select语句中，如下所示：

  select major, max (avg_gpa)
    from (select major, avg(gpa) AS avg_gpa
    from lab5_student
    group by major);

这应该是可行的。

Answer 2

Select y.* from
(
 SELECT MAX(avg_gpa) as max_avg_gpa
 FROM (
       SELECT major,AVG(gpa) AS avg_gpa
       FROM lab5_student
       GROUP BY major
      )v
 )x
 inner join

(
       SELECT major,AVG(gpa) AS avg_gpa
       FROM lab5_student
       GROUP BY major
)y
on x.max_avg_gpa=y.avg_gpa