摘要:
select Student.S_ID, Student.Sname, count(SC.C_ID), sum(score) from Student left Outer join SC on Student.S_ID=SC.S_ID group by Student.S_ID,Sname 阅读全文
摘要:
select S_ID,avg(score) from sc group by S_ID having avg(score) >60; 阅读全文
摘要:
select a.s_id from (select s_id,score from SC where C_ID='001') a,(select s_id,scorefrom SC where C_ID='002') b where a.score>b.score and a.s_id=b.s_i 阅读全文