SELECT t.t_id,t.t_name,c.c_name,AVG(sc.s_score)
FROM teacher t
LEFT JOIN course c ON c.t_id=t.t_id
LEFT JOIN score sc ON sc.c_id
-- 21、查询不同老师所教不同课程平均分从高到低显示
最新推荐文章于 2023-01-10 17:58:07 发布
SELECT t.t_id,t.t_name,c.c_name,AVG(sc.s_score)
FROM teacher t
LEFT JOIN course c ON c.t_id=t.t_id
LEFT JOIN score sc ON sc.c_id