select a.sid,sname,avg(b.score) from Student a
left outer join SC b on a.sid=b.sid
group by a.sid
order by avg(b.score) desc;
Student表:
SC表:
Teacher表:
Course表:
select a.sid,sname,avg(b.score) from Student a
left outer join SC b on a.sid=b.sid
group by a.sid
order by avg(b.score) desc;
Student表:
SC表:
Teacher表:
Course表: