1.
select Sname,Sdept from S where Ssex='男' and Sage >= 20
2.
select S.Sname,C.Cpno,T.Tname,SC.Grade from S,C,SC,T
where S.Sno=SC.Sno and SC.Cno=C.Cno and C.Tno=T.Tno
and SC.Grade<60
3.
select S.Sno,S.Sname,C.Cpno,SC.Cno,SC.Grade from S,C,SC,T
where S.Sno=SC.Sno and SC.Cno=C.Cno and C.Tno=T.Tno
and S.Sclass=‘22001’
1) select sname,sdept from S where Ssex='男' and Sage>=20
2) select sname,Cname,Tname,Grade from s inner join sc on s.Sno=sc.sno inner join c on c.cno=sc.cno inner join T on T.Tno=c.Tno
3) select sno,sname,cno,Grade from s inner join sc on s.sno=sc.sno inner join c on c.cno=sc.cno where
sclass='22001'
半路出家,让我直接写sql语句我会,关系代数不懂是什么,我也关注求教学习下。
前面回答的不是sql语句?关系代数是这个?