34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT T.T#, T.TNAME, CAST(AVG(O.score)AS DECIMAL(18,2))AS AVG_SCORE
FROM Teacher AS T, Course AS C, SC AS O
WHERE T.T# = C.C# AND C.C# = O.C#
GROUP BY T.T#, T.Tname
ORDER BY AVG_SCORE DESC;
select m.T# , m.Tname , cast(avg(o.score) as decimal(18,2)) avg_score
from Teacher m , Course n , SC o
where m.T# = n.T# and n.C# = o.C#
group by m.T# , m.Tname
order by avg_score desc