SQL在选课表中查询每门课程的选修人数,选课成绩的最高分.

Question

如题所述

Answer 1

select Lesson,max(Score) as Max_Score,count(*) as Qty from Schedule group by lesson本回答被网友采纳