select a.sid, sname, sage, ssex, score
from Student a
inner join (
select sid,score from SC
where score<60 and cid ='001'
)as b
on a.sid = b.sid
order by score desc ;
Student表:
SC表:
Teacher表:
Course表:
select a.sid, sname, sage, ssex, score
from Student a
inner join (
select sid,score from SC
where score<60 and cid ='001'
)as b
on a.sid = b.sid
order by score desc ;
Student表:
SC表:
Teacher表:
Course表: