![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
下面第7 ~10题基于这样的3个表,即学生表s、课程表c和学生选课表SC的关系模式如下。 s(S# ,SN,SEX,AGE,DEPT) (学号,姓名,性别,年龄,系别) c(C#,.CN)(课程号,课程名称) sc(S#,C#,GRADE)(学号、课程号,成绩) 所有比“”年龄大的学生姓名、年龄和性别。下面正确的SELECT语句是
A.
SELECT SN,AGE,SEX FROM S WHERE AGE> (SELECT AGE FROM S WHERE SN='华’)
B.
SELECT SN,AGE ,SEX FROM S WHERE SN='华’
C.
SELECT SN,AGE,SEX FROM S WHERE AGE> (SELECT AGE WHERE SN='华’)
D.
SELECT SN,AGE,SEX FROM S WHERE AGE>华. AGE