查询不同老师所教不同课程平均分从高到低显示
SELECT t.t_name,AVG(s.s_score) FROM teacher t,course c,score s WHERE t.t_id=c.t_id AND s.c_id=c.c_id GROUP BY c.c_id ORDER BY AVG(s.s_score) DESC
05-28
4074
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-10
4488
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
查询不同老师所教不同课程平均分从高到低显示
SELECT t.t_name,AVG(s.s_score) FROM teacher t,course c,score s WHERE t.t_id=c.t_id AND s.c_id=c.c_id GROUP BY c.c_id ORDER BY AVG(s.s_score) DESC