Highest and lowest average query scores

CSDN Q & A 2021-12-30 05:37:27 阅读数:758

highest lowest average query scores

From everyone's GPA , Find out the students with the highest and lowest average scores .




Refer to the answer 1:

select stu.name,max(avg( achievement )),min(avg( achievement )) from stu,score where stu.id = score.stuid group by stu.id




Refer to the answer 2:
版权声明:本文为[CSDN Q & A]所创,转载请带上原文链接,感谢。 https://primo.wiki/2021/12/202112300537256384.html