已知表S(Sno,SNAME,SAGE),表C(Cno,CNAME),表SC(Sno,Cno,GRADE)。其中Sno是学生号,SNAME是学生姓名,SAGE是学生年龄,Cno是课程号,CNAME是课程名称。要查询选修“ACCESS”课并且年龄不小于20的全体学生姓名的SQL语句是: SELECT s.sname FROM s join c join sc on s.sno=sc.sno and c.cno=sc.cno WHERE子句。这里的WHERE子句的内容是( )。
选项:
A:S.Sno = S
C:Sno and
C:Cno = S
C:Cno and SAGE in>=20 and CNAME in 'ACCESS'
B:SAGE>=20 and CNAME='ACCESS'
C:S.Sno = S
C:Sno and
C:Cno = S
C:Cno and SAGE>=20 and CNAME='ACCESS'
D:SAGE in>=20 and CNAME in 'ACCESS'
发布时间:2024-06-05 13:49:40